Tip 209 – Quickly Get Totals for Filtered Data in Excel
DOWNLOAD PDF Configuring Excel data as a table lets you filter data and perform calculations on the filtered results. To do this, select your data (including headings), and choose Format Table from the Home tab on the ribbon. Right click the data, choose Table > Totals Row. Create a total for any column by selecting […]
Tip 207 – Excel – Quickly add another data series to a chart
DOWNLOAD PDF When you need to add an additional data series to an Excel chart you can do so by first selecting the new data. If you included column headings in your data selection when you first created the chart then include the column heading in this selection too. Click Copy on the Home tab, […]
Tip 204 – Quickly Rotate Column Headings in Excel
DOWNLOAD PDF When your column headings are longer than the data you are entering into a column, you can rotate the headings so they take less room. To do this, select the column headings and from the Home tab on the Ribbon, choose Orientation and then an option such as Rotate Text Up. Now select […]
Tip 203 – Quickly Rearrange Your Data in Excel
DOWNLOAD PDF If you find after entering data into an Excel worksheet that you have it arranged in columns when it might be better arranged in rows (or vice versa) you can reorder it. To do this, select all the data including the column and row headings and, from the Home tab on the ribbon, […]
Tip 201 – Save Confusion by Including Column and Row Titles on Excel Printouts
DOWNLOAD PDF When your worksheet prints on multiple pages you can make it easier to read by printing column headings and row titles on the printout. Choose Page Layout > Print Titles and click in the Rows to repeat at top box and type 1:1 to select to print the first row on all pages […]
Tip 196 – Quickly Start a New Line when Entering Text Into a Cell in Excel
DOWNLOAD PDF When you need to start a new line when typing text in an Excel cell you can’t use the Enter key as that will commit to entering the data into the cell. Instead use the key combination Alt + Enter to start a new line when entering data into an Excel cell. Use […]
Tip 195 – Easily Add a Text Box to an Excel Chart
DOWNLOAD PDF To add text to your chart, first click on the chart to select it. In the ribbon, select the Chart Tools Layout tab and select Chart Area from the dropdown menu at the top right if it is not already selected. Under Insert select Shapes and choose the rectangle shape. Click and drag […]
Tip 194 – Quickly Widen Bars on Excel Bar Charts
DOWNLOAD PDF When the bars or columns on a chart are very narrow you can widen them to make the chart more easily read. To do this, click on a series to select it, right click and choose Format Data Series. Decreasing the Gap Width will result in the bars or columns being made wider. […]
Tip 192 – Easily Find Unusual Characters in an Excel Worksheet
DOWNLOAD PDF If you’re looking for characters such as an asterisk (*) or question mark (?) in an Excel worksheet you’ll encounter problems. These symbols are used as wildcards so they represent other characters so you cannot search for them as you would any other keyboard character. Instead typing ~? or ~* in the search […]
Tip 191 – Quickly Adjust Margins Before Printing an Excel Worksheet
DOWNLOAD PDF You can quickly adjust the page margins before printing a worksheet using the margins tool in the Preview screen. Choose File > Print (and click Preview in Excel 2003 and 2007). Click the Show Margins icon in Excel 2010 & 2013 (click the Show Margins link in Excel 2007 and click Margins in […]