News

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.
Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...
How to alternate row colors in Excel To apply color in alternate rows or columns in Excel, follow these steps- Open the spreadsheet with Excel. Select the rows and columns that you want to colorize.
Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.
How to Sum a Column of Zeros in Excel. You can use the Sum function in Microsoft Office Excel to sum columns of data, whether your data is in an Excel table or is simply a range in a column of ...
You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.
Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.
1. In Excel, select the cell, group of cells, or entire column that has the text you want to split. It'll need to contain two pieces of data separated by a "delimiter." ...
The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.
However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...
Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column ...
If you want to spell check specific regions, parts, cells or columns of your Excel spreadsheet, then here's how you can do it. No need to spellcheck the entire document!