///

Excel 101: Part 2 – Cell, Row and Column Adjustments

4 mins read

This article is written to provide a “how to” when adjusting cells, rows, and columns.

Previously, we introduced you to Excel and what cells, rows, and columns are. In this article we are going to discuss how you can adjust them.

Inserting Rows and Columns
To insert a row and column, you will click on the number or letter where you want to insert the cells, which will highlight the area. Once the area has been highlighted, right click the number or letter to open the option box and select ‘Insert.’ (See Right)

After this, cells will be inserted in the area which was highlighted. (See Left)

 

Pro Tip: Try to insert cells in the middle of data instead of at the bottom. This way, if there are any totals at the bottom, you do not need to readjust those formulas. You can always use the auto-filter feature to make sure the data is filtered in the manner that suits the reports.

Deleting Rows and Columns
To delete a row and column, you will follow the same steps as above. Instead of selecting ‘Insert,’ you will choose ‘Delete.’ (See Right)

After this, cells will be deleted in the area which was highlighted. (See Left)

Hiding and Unhiding Rows and Columns

In instances where you may want to hide certain rows or columns for confidentiality reasons, this can be easily accomplished by highlighting the row or column you want to hide, following the same steps as discussed above. However, instead of selecting ‘Insert’ or ‘Delete,’ you will select ‘Hide.’

When you hide cells or columns, please know that the data is still present in the workbook, it is just not showing. (See Left)

To unhide cells or columns, you will highlight the column or row next surrounding the hidden cells; following the steps as before, select ‘Unhide.’ (See Right)

Adjusting Rows and Columns Size

You may need to adjust the size of the cells to fit the data stored. To do this, go to the edge of the letter or number cell until you see an adjustment icon <|>. Once you see this, left click and pull the cell to fit all stored data. You also have the option to double-click, which will autofit the stored data in the row or column.

Say you want all rows and columns to be the exact same sizes. Highlight the full spreadsheet by clicking the icon where the red arrow (See Left) is pointing or type Ctrl + A on your keyboard.

Once the full page has been highlighted, right-click on any Row or Column header and from the option box, select ‘Column Width’ or ‘Row Height.’

When you select one of these options, it will open a small window where you can adjust all Column Widths or Row Heights in one go!

This brings us to the end of basics relating to Cells, Rows, and Columns. Please stay tuned for part 3 of this series when we discuss Formulas and Functions, which are built-in features to assist businesses with reporting and calculations.

Download this resource Excel 101: Part 2 – Cell, Row & Column Adjustments.

click to enlarge

Visit our Resource Library for all available downloads.

If you require assistance with any of the guides, forms or templates, please contact a BIG representative.

Latest from Featured Posts

Login / Logout

Previous
Next
Previous
Next

Do You Want to Learn More About Membership? Click Here

Do You Want to Learn More About Membership? Click Here

How Can We Help?