Microsoft Excel: Turn table headers on or off
When you create an Excel table, a table Header Row is automatically added as the first row of the table, but you have...
Microsoft Excel: How to print row and column headers on every page
In printing spreadsheets; the top row is printed only on the first page. Here is how to repeat the header...
Microsoft Excel: Header and Footer – Insert, Edit and Remove
To make your printed Excel documents look more stylish and professional, you can include a header or footer on each...
Microsoft Excel: Text to Columns
Data imported from other spreadsheets or databases is already separated into fields, using something called a field delimiter: a comma,...
Microsoft Excel: Concatenation
Concatenation – What is it? The CONCAT function is one of Excel’s text functions. It is used to join two...
Microsoft Excel: Transpose (rotate) Data from Rows to Columns or Inversely
If you have a worksheet with data in columns that you need to rearrange into rows; use the Transpose feature. With it,...
Microsoft Excel: Keyboard shortcuts
Do you find using a mouse to manage your Excel worksheet a bit of an annoyance? Would you rather command...
Microsoft Excel: How to freeze Rows & Columns
Freeze the Top Row or First Column 1. Click on the View tab on the Excel Ribbon. 2. Click the...
- 1
- 2