In this lesson I explain how to insert a column and why you would want to when using the DIY Spreadsheets. This is going to have you do things that I won’t explain now but in upcoming lessons. I just wanted to show you how to do something that can help you start using the data.
Insert a Column
Move the cursor to area above column that you want to insert a column before. Columns are inserted before the selected column or above the selected row. This makes sense when you think about it otherwise how you would insert a column before the very first column?
In this example, I’m inserting a column before the Name column, column C. Right Click and select Insert.
Insert Multiple Columns
You can insert multiple columns at once by highlighting a column and while holding down the left button, move the mouse toward the right to select the number of columns you want to add. In this example, I’ll be adding four columns before the Name column, column C.
A Word about Formatting
In the first examples of inserting columns, the new columns have the same formatting as the column next to it.
Excel will format new columns the same as the columns to their left. In the example below, the columns are formatted grey even though I highlighted a column with blue formatting for the insertion point. The new column T has the same formatting as column S.
Why Insert a Column
I suggest you enter a column before the Name column as seen below.
You can use this column to start selecting or ranking the schools. I’m going to show you a basic option for right now that I call the “use” option. I name the column Use. Click on the top row of the column and just type in the word “Use” and hit enter.
Depending on what I’m evaluating the schools for, I type “yes” into the column. I could also type “no” but I generally don’t have any need to. This is using “text” data which I will go into more detail in later lessons.
You can display only the schools you currently want to use in the spreadsheet by clicking on the drop-down arrow at the top of the Use column and unchecking Select All and then checking yes.
Now you will only see the schools where you have entered “yes” under the Use column.
I’m going to go into more detail on filters and data types in future lessons. Hopefully, this is enough to get you started on identifying schools most likely to meet your needs and preferences.