How to Print the Top Row or Column on Every Page in Excel

How to Print the Top Row or Column on Every Page in Excel

One can set options to print the sheet's headings or titles on each page if they need to print a sheet that will have many printed pages. Excel normally is automated to provide headings for columns (A, B, C) and rows (1,2,3). You will have to type titles in your sheet that describes the content … Read more

#REF! Error in Excel – How to Fix the Reference Error

#REF! Error in Excel – How to Fix the Reference Error

A #REF error is a message that Excel sends when the formula references a cell that is no longer available, maybe because it has been deleted. If you have worked with formulas in Excel, you have likely come across this error. It appears when the formula has no idea where to point to as it … Read more

How to Rotate Text Cells in Excel

How to Rotate Text Cells in Excel

There are several ways to rotate texts in excel. They include using the ribbon Format dialog box, keyboard shortcuts, and default settings by changing the text orientation back to Horizontal. Rotating Text using Ribbon Alignment option Follow these steps: 1. Choose all the cells with headers 2. Click on the Home tab 3. Click on … Read more

How to Remove Line Breaks in Excel

How to Remove Line Breaks in Excel

Through line breaks, the same cell has multiple lines in Excel. However, these lines are unnecessary, so you may want to remove them from your dataset. There are different ways to remove line breaks in Excel. Using Find and Replace Method It is considered the easiest way of removing line breaks manually in Excel. The … Read more

How to Turn Autosave in Excel

How to Turn Autosave in Excel

Even though Microsoft Excel has improved over the years, it is still possible to crash when working with a large data set. Factors outside Excel such as power failure could cause it to crash. You may easily lose your data if your work was not saved in the first place. However, Excel has an AutoSave … Read more

How to Insert and Delete Comments in Excel

How to Insert and Delete Comments in Excel

Comments are quite useful in Excel, especially when inserting formulas, and there is a need to specify what the formula does and what a cell value means. It is also important to add comments when collaborating with others for their reference. This tutorial shows you how to add comments, edit, and delete them in Excel. … Read more

Excel How to Freeze the Top Row and First Column

How to Freeze the Top Row and First Column

When we are using our worksheet, at some point, we need to see the heading of columns and the titles in the first row. We need to freeze the first column and the first row to do this. After freezing the two, you will always see the first row and the first column when you … Read more

Excel How to Hide Gridlines

How to Hide Gridlines

Most excel users confuse cell gridlines and cell borders. Excel gridlines are customized differently to the borderline. In excel, gridlines are displayed using a default color assigned by excel. If you need to change the color of the gridline for your worksheet, it's possible. To most users, you know hiding gridlines is common. In some … Read more