Below I have complied a list of Excel tips and tricks that will help you get things done faster and more efficiently . This is a series that will cover tips and tricks for all Microsoft Office products.
Click the corner button, as shown below, to select all cells in an excel file. With this one click all cells will be selected in seconds.
Also, if all cells are selected you can adjust the column width and row height to match for all cells. Simply select all cells and move the column and row cursor to the preferred width and height.
By using the Ctrl + Tab keyboard shortcut, you can shift between different files freely. It can become irritating shifting between different files.
Also if you have two excel documents open at the same time, excel will only let you view one document at a time. To avoid this, open up the documents separately where they are saved locally. Do not open up the second document through excel.
If you want all blank cells in your excel file to be deleted, the fastest way is to filter out all blank cells and delete them with one click. Follow the steps below to delete blank cells.
You can use the transpose feature to get a better display of your data, however, it would be a waste of time to retype all the data. Use the transpose feature in Paste drop-down to save time. All you need to do it copy the data area and navigate a free area on your spreadsheet. Navigate to the Home tab and use the transpose feature under the Paste drop-down, that you can see in the screenshot below.
When a value that starts with a zero, Excel will delete the zero by default. Rather than formatting the cells, this issue can be easily solved by adding a single quote mark ahead of the first zero, as seen below.
Post by Kaitlyn Reish, Training Specialist at HPU.