There are so many useful keyboard shortcuts in Microsoft Excel. Most of us have heard of ‘Ctrl‘ ‘Z‘ for undo. Perhaps ‘Ctrl‘ ‘C‘ for copy, or ‘Ctrl‘ ‘V‘ for paste. But one of the most useful ones I personally use is ‘Ctrl‘ ‘;‘ to enter the current date. Why type ‘01/15/2015‘ when you can hit Read more about Insert the current date in Excel – Keyboard Shortcut[…]
Just as you can use ALT + TAB to scrol through the opened program windows on your Windows desktop, you can do a similar thing to skip through the worksheets in Excel. To move one worksheet to the right press CTRL+PAGE DOWN To move one worksheet to the left press CTRL+PAGE UP
There’s a calculator in Excel 2010 but by default this feature is hidden, to get the calculator on your Excel screen navigate to Quick Access toolbar options – it’s the down arrow symbol next to the undo button on the top left-hand of the screen – and click More Commands. It will lead you to Read more about Add a calculator to the excel toolbar[…]
Today’s hint of the day. Even some excel experts don’t know about it. The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.