When you open an Excel spreadsheet, by default the columns are indexed by letters. However if you'd like to change the format and have the index in numbers, follow the step-by-step guide below. How to ...

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number. If ...

Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column. Excel's myriad formatting tools let you add colors, formulas and borders almost anywhere in a worksheet. You can ...

How to Copy a Format for Excel Worksheet Columns and Rows Your email has been sent Learn how to use Excel's Format Painter to apply formatting to entire rows and columns. Formatting allows viewers to ...

Do you want to split a single column of text into multiple columns in your Excel spreadsheet? Using the Text to Column feature, you can choose how to split the column up, fix the width, or split at ...

Sometimes, you may want to convert data in one column to organized data in Excel. This is especially true when you copy-paste unorganized data from a word editor to an Excel sheet. All the data is ...

Excel Conditional Formatting already lets you format cells based on the value of those cells or the value of the formulas in those cells (see our conditional formatting tutorial for more details). Now ...