Excel Solutions

How to Transpose Tables in Excel

Excel has a number of smart features which are of great importance for our work. Those Excel functions can be very helpful when we need to deal with huge amount of data. And today we will introduce an Excel tip on transposing tables. Sometimes, you need to deal with a table in an Excel file. And this document might possibly be made by others. However, the arrangement of the table doesn’t conform to your habit. And now you may need to transpose this table so that you can improve your...

Read more »

3 Must-Know Tips to Manage Your Quick Access Toolbar

Excel can be quite powerful if you can apply it expertly. Excel carries various hidden features that enable you to improve your work efficiency. And today we will introduce the Excel tips on customizing Quick Access Toolbar. The Quick Access Toolbar lies in the top of the Excel interface. In this part, you can add your commonly used function into the toolbar. You may hold the idea that this part is useless, because you can still use the functions through other ways. But actually, the Quick...

Read more »

How to Show Hidden Contents in Your Worksheet

In this article, we will introduce some Excel tips to make sure the cell contents are always visible. Excel files can be very useful in processing huge amount of data. But sometimes the default size of cell is not large enough to show all the input contents. Here we will introduce some simple and useful Excel tips to solve the problem. When you manually input your information into the Excel sheet, you will find the cases as shown below: The first column is “Student Number” and the...

Read more »