Tip 189 – Save Time When Printing Only Part of an Excel Sheet
DOWNLOAD PDF If you typically only print a small portion of an Excel worksheet you can save time by naming it. Select the area you want to print and choose Page Layout > Print Area > Set Print Area. Now, when you print the worksheet only the selected area will be printed. If you ever […]
Tip 187 – Quickly Drag and Drop to Move Rows or Columns in Excel
DOWNLOAD PDF To quickly move one or more rows or columns, first select the rows or columns to move by dragging over their row numbers or column letters. Hold your mouse over the edge of the selection until you see the 4 way arrow cursor. Hold Shift on the keyboard as you drag the selection […]
Tip 186 – Instantly Size an Excel Worksheet to Print on a Single Page
DOWNLOAD PDF To ensure your worksheet will print on a single sheet of paper, choose Page Layout and open the Page Setup dialog by clicking the dialog launcher. Select the Page tab and select Fit to 1 page(s) wide by 1 tall to shrink the sheet when printing to fit on a single sheet of […]
Tip 184 – Speed Up Data Entry in Excel
DOWNLOAD PDF You can speed up data entry in Excel by controlling the direction the cell pointer moves when you press Enter. So, to enter data across a row, or down a column configure Excel to move in the desired direction.. Choose File > Options > Advanced and in the Editing Options group of settings […]
Tip 183 – Set the Default for New Excel Files
DOWNLOAD PDF If you always change the font or typically add more sheets to each workbook you can change the defaults so you never need do this again. Choose File > Options > General and you can change the default font, font size and the number of sheets in a workbook. Make your selections and […]
Tip 180 – Quickly Indent Text Data in Excel Cells
DOWNLOAD PDF When you have a column of headings in an Excel worksheet you can draw attention to those which are lower in the hierarchy by indenting them. To do this, select the cells with the headings to indent and click the Increase Indent button on the Home tab of the Ribbon. Remember that you […]
Tip 176 – Neaten Up your Screen and Printouts by Hiding Excel Gridlines
DOWNLOAD PDF When you have a neatly formatted Excel worksheet, you may prefer to hide the gridlines from view. To do this, choose the View tab and in the Show options uncheck Gridlines. To enable or disable the grid on printed versions of the worksheet, choose File > Print. Select Page Setup > Sheet tab […]
Tip 174 – Instantly View Excel Formulas Instead of their Results
DOWNLOAD PDF When studying or troubleshooting an Excel worksheet it can help to view the cell formulas rather than the results. To do this, click the Formulas tab and click Show Formulas € you may need to widen the columns to see the full text of long formulas. Click this icon again to return to […]
Tip 171 – Quickly Copy an Excel Sheet Using Drag and Drop
DOWNLOAD PDF Skip the menus and copy an Excel worksheet by using drag and drop. To do this, click the tab of the sheet to copy and hold Control as you drag a duplicate of the sheet into the desired position in the workbook. When you’re done, double click the sheet tab and change its […]
Tip 169 – Clean Up your Worksheets by Hiding Zero Values
DOWNLOAD PDF If you have an Excel worksheet that contains many zero values which you don’t want to display, you can easily hide them. To do this, choose File > Options > Advanced and scroll to the Display options for this worksheet settings. Disable the Show a zero in cells that have zero value checkbox […]
