How to Anchor formatting cells?
Anchor Formatting Cells
Have you ever experienced erroneous results and copying and pasting your formula? These problems may arise due to not anchoring the correct cells.
Anchoring is very useful to maintain the consistency of calculations.
See for yourself, how it can save ridiculous amount of time while managing your data.
Changing cell Reference to Absolute with pressing F4 key
- Double click on the cell to go to formula edit mode
- Press F4 till $ sign appears
- Repeatedly press F4 till all the row and column references have $ sign i.e. the reference is changed to absolute now.
Now you can copy the formula from the cell without worrying about some unexpected results.
Grouping Cells
If you are working on a worksheet containing lots and lots of data. It become tedious to navigate around the worksheet. It may be a good idea to group the cells to organize your data for efficient workflow.
Excel can organize data in groups, allowing you to easily show and hide different sections of your worksheet.
How to group cells?
- Select the table or part of the table or your desired area to be grouped
- Go to Data Tab –> Click on Group under the Outline group
- A dialog box will appear asking whether the selection is to be grouped by Column or Rows.
Here we have selected to group by column. And then click on OK.
You’ll now notice that your selection is now grouped.
You can also hide the group by clicking on the – (minus) button.
