Microsoft Excel: How to Add a Watermark to a Worksheet
Do you still think that you can’t add a watermark to your Excel worksheet? I have to say that you...
Microsoft Excel: How to insert page numbers
This article explains page numbering in Excel. Find out how to insert page numbers in Excel if your workbook contains...
Microsoft Excel: How To Create Custom Templates
Odds are pretty good that you create the same types of Excel spreadsheets over and over again. Creating a custom...
Microsoft Excel: How to add an always visible Top Row in a table
To add an always-visible title, you can place it in the top row of your spreadsheet. 1. First we are...
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,...