Excel Tip No. 1; Adjust Width of One or Multiple Columns
It is easy to adjust a column to the width of its content and get rid of those useless####entries. Click on the column's header, move your cursor to the right side of the header and double click when it turns into a plus sign.
Excel Tip No. 2: Copy a Pattern of Numbers or Even Dates
Another amazing feature built into Excel is its ability to recognize a pattern in your data, and allow you to automatically copy it to other cells. Simply enter information in two rows which establish the pattern, highlight those rows and drag down for as many cells as you want to populate. This works with numbers, days of the week or months!
Excel Tip No. 3: Tab Between Worksheets
Jumping from worksheet to worksheet does not mean you have to move your hand off the keyboard with this cool shortcut. To change to the next worksheet to the right enter CTRL + PGDN. And conversely change to the worksheet to the left by entering CTRL + PGUP.
Excel Tip No. 4: Double Click Format Painter
Format Painter is a great tool which lets you duplicate a format in other cells with no more effort than a mouse click. Many Excel users (Outlook, Word and PowerPoint too) use this handy feature, but did you know you can double-click Format Painter to copy the format into multiple cells? It is quite a time-saver.
It is easy to adjust a column to the width of its content and get rid of those useless####entries. Click on the column's header, move your cursor to the right side of the header and double click when it turns into a plus sign.
Excel Tip No. 2: Copy a Pattern of Numbers or Even Dates
Another amazing feature built into Excel is its ability to recognize a pattern in your data, and allow you to automatically copy it to other cells. Simply enter information in two rows which establish the pattern, highlight those rows and drag down for as many cells as you want to populate. This works with numbers, days of the week or months!
Excel Tip No. 3: Tab Between Worksheets
Jumping from worksheet to worksheet does not mean you have to move your hand off the keyboard with this cool shortcut. To change to the next worksheet to the right enter CTRL + PGDN. And conversely change to the worksheet to the left by entering CTRL + PGUP.
Excel Tip No. 4: Double Click Format Painter
Format Painter is a great tool which lets you duplicate a format in other cells with no more effort than a mouse click. Many Excel users (Outlook, Word and PowerPoint too) use this handy feature, but did you know you can double-click Format Painter to copy the format into multiple cells? It is quite a time-saver.
0 comments:
Post a Comment