Hide Columns or Rows in Excel – Instructions and Video Lesson

Hide Columns or Rows in Excel - Instructions: A picture of a user hiding selected columns in an Excel workbook.
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 - Instructions and Video Lesson: A picture of a user resizing selected columns in an Excel workbook.
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 - Instructions and Video Lesson: A picture of a user printing a selected chart in Excel.
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

Copy and Paste List Data from Excel into QuickBooks Pro- Instructions

Copy and Paste List Data from Excel into QuickBooks Pro- Instructions: A picture of the “Add/Edit Multiple List Entries” window in QuickBooks Pro.
Copy and Paste List Data from Excel into QuickBooks Pro: Overview             A feature that improves the speed of company file creation is the ability to copy and paste list data from Excel into QuickBooks Pro. You can copy and paste list data from Excel into QuickBooks Pro to add it into the “Customers,” “Vendors,”
Read more
No Comments

Apply Password Protection to an Excel File – Instructions

Apply Password Protection to an Excel File - Instructions: A picture of a user adding a password for opening the Excel file to a workbook.
Apply Password Protection to an Excel File: Overview             When you apply password protection to an Excel file, you prevent people from opening it without knowing the required password. After password protection is enabled on a file, no one can open it without the password. Therefore, password-protecting files poses some risk. This is because if
Read more
No Comments

Record a Macro in Excel – Instructions and Video Lesson

Record a Macro in Excel - Instructions and Video Lesson: A picture of the “Record Macro” dialog box in Excel.
Record a Macro in Excel: Overview              You can easily record a macro in Excel. Macros are small programs that record your actions as you perform a task in Excel. The actions are then saved as a Visual Basic Module, which is a type of program. When you run the macro later, it repeats your
Read more
No Comments

Outline Excel Data in Microsoft Excel – Instructions

Outline Excel Data in Microsoft Excel - Instructions: A picture of an Excel worksheet with an outline applied.
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

Split Panes in Excel – Instructions and Video Lesson

Split Panes in Excel - Instructions and Video Lesson: A picture of a large Excel workbook that is horizontally split into two separate panes.
Split Panes in Excel: Overview             To split panes in Excel when viewing a large worksheet, use the “Split” command in Excel. This command lets you split the Excel worksheet into different panes. Each pane contains its own horizontal and vertical scroll bars. Therefore, you can scroll each pane separately to view information from different
Read more
No Comments