Hide Columns or Rows in Excel – Instructions and Video Lesson

Hide Columns or Rows in Excel: Overview             You can hide columns or rows in Excel that contain sensitive data. You can do this to hide data you need for formulas but don’t want to show in a worksheet, like salary information, for example. Hiding a column or row conceals its display, but still uses
Read more
No Comments

Resize Columns and Rows in Excel – Instructions and Video Lesson

Resize Columns and Rows in Excel: Overview             There are many ways to resize columns and rows in Excel. You can adjust the width of columns to correct the display of longer cell entries. You can also adjust row height to accommodate larger fonts. To resize columns and rows in Excel, you must first select
Read more
No Comments

Print a Chart in Excel – Instructions and Video Lesson

Print a Chart in Excel: Overview             To print a chart in Excel that appears embedded in a worksheet without printing the rest of the worksheet, select the chart or one of the chart’s elements, first. Alternatively, to print a chart in Excel that appears embedded in a worksheet along with its accompanying worksheet data, click into
Read more
No Comments

Outline Excel Data in Microsoft Excel – Instructions

Outline Excel Data in Microsoft Excel: Overview             You can outline Excel data to add an organizational quality to a long or wide worksheet. When you outline Excel data, you group worksheet data into different levels based on column and row headings. Lower level data is associated with the headings in the rows or columns.
Read more
No Comments

Change the Chart Type in Excel – Instructions

Change the Chart Type in Excel: Overview             After creating a chart, you can change the chart type in Excel. Alternatively, you can also choose a different sub-type of the same general chart type you first selected. Either way, note that if you change the chart type, you may lose custom formatting you have applied
Read more
No Comments

Move a Chart in Excel- Instructions

Move a Chart in Excel: Overview             You can easily move a chart in Excel. When you insert a new chart into a worksheet, it appears as an embedded chart object in the worksheet. When you embed a chart in a worksheet, you can move it and also resize it in the worksheet. Before you
Read more
No Comments

Set Margins in Excel – Instructions

Set Margins in Excel: Overview             To set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group. Then click
Read more
No Comments

Trace Error in Excel – Instructions and Video Lesson

Trace Error in Excel: Overview             Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error. The Trace Error tool is available when auditing a worksheet within a workbook. Note that the formula cell that you select must contain an error to use the Trace Error
Read more
No Comments