Tip #111 - Excel - 10 Time-savers

100 (or more) Computer Tips in 100 (or more) Days

Tip #111 - Excel - 10 Time-savers

Here's a list of some really little things that you can use in Excel that can add up to big savings in time at the end of the day.  They are in no particular order. Enjoy.

• Double-click in a cell to edit the contents - no need to go up to the Formula Bar to edit.
• Double-click a sheet tab to rename it then press the Enter key.
• Tap the F4 (function 4) key to create an absolute reference in a formula. Tapping it again will cycle through mixed references (where only one $ appears) and then back to relative reference (where no $ appear).
• Rearrange sheets by dragging the sheet tab left or right. A small triangle moves with your mouse showing the new position of the moved sheet.
• Change the color of a tab by right clicking (Ctrl click on Apple) and choosing your favorite color.
• Duplicate a sheet by holding down the Ctrl key and dragging the sheet tab to the left or right. This duplicates not only the contents but all of the print, orientation, margin, header & footer settings, infinitely superior to copy and paste.
• Use the group edit to make the same change to multiple sheet at the same time. To get into the group edit, click on one sheet, hold down the Ctrl key and click on additional sheets. To get out of the group edit click on any sheet tab that is not part of the group. This is a BIG time saver if you are adding an entry or a row/column to multiple sheets. BONUS: If you use the print command while in the group edit all of the sheets in the group will print.
• Double-click on the vertical line between the column letters at the top of the column to adjust the column width to "best fit", no need to drag and guess how wide the column should be.
• Press the Esc key to get rid of the marque (dancing ants) around copied cells. This also empties the computer's clipboard.
• When you use the filter command (on the Home tab, Editing group) you will not only be able to sort and filter the columns by alpha and numeric contents but you will have color as an option for sorting and filtering.  This assumes that you have formatted cells with color.

Write a comment and let me know which of these is your favorite time saver.

Happy Computing!

Diane

Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com .