Home / Tag Archives: excel

Tag Archives: excel

How To Lock Cells Based On Color In Microsoft Excel

Microsoft Excel lets you apply conditional formatting to cells. If the value in a cell meets certain rules that you’ve set, the conditional formatting feature will change the color of the text in the cell, or the fill color, or both. This is a basic feature that works right out …

Read More »

How To Select Only Visible Cells In Excel

Excel lets you hide columns and rows.This is a great way to make a clean, presentable Excel sheet. You can insert formulas in rows and columns, and hide them later. It also keeps other users from editing your formula. If the formula isn’t visible, chances are people are less likely …

Read More »

How To Remove All Hyperlinks In An Excel Sheet

Microsoft’s productivity suite of apps support rich text formatting and a whole host of other elements. You can change the font size, color, and type but you can also add images, tables, shapes, videos, links to external documents, and hyperlinks. This isn’t even the tip of the iceberg though. The …

Read More »

How To Sort Data In Rows In Excel

Microsoft Excel is a powerful spreadsheet app. It lets you process a substantial amount of data. You can sort it, apply formulas, and use conditional formatting to make it easier to read. Add to this the many types of graphs it supports and you can get a lot done with …

Read More »

How To Stop Numbers Converting To Date In MS Excel

MS Excel is an exceptionally intelligent spreadsheet app and it’s not just because it supports a lot of logical arguments. The app can recognize data for what it is, e.g. it knows when it’s dealing with currency, and when it’s dealing with time values. It’s precisely because of this that …

Read More »