![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](https://cdn.extendoffice.com/images/stories/doc-excel/highlight-based-on-multiple-values/doc-highlight-contains-any-words-1.png)
Pressing Ctrl+A a second time selects the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region. To select the entire worksheet, you can also press Ctrl+A. You can scroll to make the last cell visible. To stop extending the selection, press F8 again.Ĭlick the first cell in the range, and then hold down Shift while you click the last cell in the range. You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys.
Conditional formating with spreadsheet converter how to#
How to select cells, ranges, rows, or columnsĬlick the cell, or press the arrow keys to move to the cell.Ĭlick the first cell in the range, and then drag to the last cell, or hold down Shift while you press the arrow keys to extend the selection. On the worksheet, select any single cell or range of cells that has an error indicator in the upper-left corner. If this isn't what you want, you can follow these steps to convert the number that is stored as text back to a regular number. This error indicator tells you that the number is stored as text, as shown in this example. If you import data into Excel from another source, or if you type numbers into cells that were previously formatted as text, you may see a small green triangle in the upper-left corner of the cell.
![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](https://www.syncfusion.com/products/javascript/control/images/ejspreadsheet/conditional-formatting.png)
Technique 3: Apply a number format to text-formatted numbers Technique 2: Convert text-formatted numbers by using Paste Special Technique 1: Convert text-formatted numbers by using Error Checking
![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](https://i.ytimg.com/vi/TXugoHxjEBE/maxresdefault.jpg)
Numbers that are formatted as text are left-aligned instead of right-aligned in the cell, and are often marked with an error indicator. This issue sometimes occurs after you import or copy data from a database or other external data source. In some cases, numbers in a worksheet are actually formatted and stored in cells as text, which can cause problems with calculations or produce confusing sort orders.