In this video, staff author Jess Stratton shows users how to work with rows and columns in Excel, including inserting, deleting, rearranging, and resizing them.
- [Instructor] Let's talk about some ways…that you can manipulate rows and columns in Excel.…The first thing that you might want to do…is delete an entire column, or row.…The easiest way to do that…is to click on either the number in the row…or, the letter in the column.…It's going to highlight the entire column.…From here, I can either click Delete…from the Home ribbon tab.…Or, I can right click with my mouse…and choose Delete.…I can also make my column widths look much nicer…if I'm trying to clean this up a bit.…I can drag my mouse to resize them manually.…
And I do that by hovering my mouse…on the right hand side of the column border.…From here, I can drag the data out.…I can also double click on that exact same spot…to have it resize automatically…to the exact size of the data.…We can also format our text.…I have here a United States zip code column…and I can see that it's not properly formatted.…You can format an entire column…by clicking to highlight the entire column…and changing the data type.…
I'll click this down arrow next to number…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Converting Google Sheets to Excel format
- Working anywhere with Excel Online
- Working with sheets
- Creating an Excel table
- Applying conditional formatting
- Working with formulas
- Working with charts and sparklines
- Sharing files and collaborating with others
- Reviewing and tracking changes