Tip 225 – Quickly Add and Remove a Data Series from an Excel Chart
DOWNLOAD PDF You can quickly delete a series from an Excel chart by clicking on the series in the chart and press Delete on the keyboard. To add a series to a chart, select the data for the series including the column or row heading and choose Copy or press Control + C. Click on […]
Tip 224 – Quickly remove all the formatting from an Excel sheet
DOWNLOAD PDF To remove all the formatting from an Excel worksheet, click the indicator between the rows and columns in the top left corner of the worksheet to select the entire worksheet. From the Home tab on the Ribbon, locate the Editing group and choose Clear > Clear Formats. This removes all formatting except custom […]
Tip 223 – Easily Type Leading Zeros in Excel
DOWNLOAD PDF When you need a cell to contain a value that may contain a leading zero you can configure the cell so this zero shows. Select the cells to contain this value, right click and choose Format Cells > Number tab. Click Custom and, in the Type box, type one less zero than the […]
Tip 222 – Easily align objects to Excel’s columns and rows
DOWNLOAD PDF If you are experiencing difficulty lining up objects such as charts, images and text boxes on a worksheet a simple shortcut will help. Hold the Alt key as you drag an object and its edge will snap automatically to the edge of the nearest cell.
Tip 221 – Quickly Shade Alternate Rows in Excel
DOWNLOAD PDF Using a handy conditional formatting technique you can shade alternate rows in Excel. Select all the cells in the range to apply the shading to and choose Conditional Formatting > New Rule on the Home tab of the ribbon. Choose Use a formula to determine which cells to format and type this into […]
Tip 218 – Quickly Duplicate Merged Cells in Excel
DOWNLOAD PDF When you are creating a form in an Excel worksheet you will often be creating merged cells for your data. If you need to create a series of merged cells adjacent to each other create the first merged cell then drag that cell’s fill handle to create additional merged cells.
Tip 217 – Hide Page Breaks for an Excel Worksheet
DOWNLOAD PDF After you choose View > Page Break to check how a worksheet will print, page breaks will be visible on the screen even after you return to Normal view. To hide these, choose File > Options > Advanced and locate the Display Options for this Worksheets section. Disable the Show Page Breaks checkbox […]
Tip 215 – Quickly Move an Excel Chart to its Own Sheet
DOWNLOAD PDF Sometimes you’ll find you need to move an Excel chart to its own sheet instead of leaving it embedded on the same sheet as its data. To do this, select the chart border and right click. Choose Move Chart, click the New Sheet option, type a name for the chart sheet and click […]
Tip 214 – Quickly convert an Excel formula into a value
DOWNLOAD PDF When you have a formula that you want to replace with a permanent value you can do this easily by clicking in the cell containing the formula. Click at the end of the formula in the Formula Bar and press F9. This converts the formula to a calculated value. Now press Enter to […]
Tip 213 – Quickly Format Excel Cells Using Keyboard Shortcuts
DOWNLOAD PDF Speed up cell formatting with these easy to remember Excel formatting shortcuts: Control + Shift + $ Currency, two decimal places Control + Shift + % Percentage format, no decimal places Control + Shift + ! Comma, two decimal places Control + Shift + # Date format (d-mmm-yy) Control + Shift + & […]
