Naneedigital
Cells
Excel 2010 Using Non-Contiguous Name Ranges
How to Name a Large Range of Non-Contiguous Cells in Excel Select the non-contiguous cells that you want to name. Open up the Visual Basic Environment...
swap 2 cells in excel
Manually swap two adjoining cell contents Select the cell you want to swap. In this example, select cell A4. Press Shift key, and put the cursor at th...
How To Lock Cells Based On Color In Microsoft Excel
How do I lock cells with color in Excel? Can you conditionally lock a cell in Excel? How do I conditional cells in Excel by color? How do I lock a cel...
How to Merge Cells, Columns and Rows in Excel
Combine rows in Excel with Merge Cells add-in Select the range of cells where you want to merge rows. Go to the Ablebits Data tab > Merge group, cl...
How to skip conditional formatting blank cells in Microsoft Excel
If you want to skip conditional formatting for blank cells, select 'Format only cells that contain' and select 'Blank' under the Edit the Rule Descrip...