![]() ![]() Grab this simple piece of code if you need to move the columns apart.ĭim colNo, colStart, colFinish, colStep As LongĬolStart = (1, 1).Column + 1ĬolFinish = (( _ So, I couldn't leave this post without a macro. Many Excel users try to save as much time as possible by automating frequent spreadsheet tasks. A special VBA macro to insert every other column The new column will be named Column1 by default. Then pick Insert -> Table Columns to the Right for the last column or Table Columns to the Left. To insert a column, you need to select the necessary one and right click on it.Ģ. You can also pick the option Insert Table Columns to the Left for any column in your table.ġ. ![]() If your spreadsheet is formatted as Excel Table you can you can select the option Insert Table Columns to the Right if it's the last column. Add a column to a list formatted as Excel Table Press Ctrl + Shift+ + (plus on main keyboard) to see several new columns inserted en masse. The newly inserted columns will appear to the left.Ģ. Select several non-adjacent columns by clicking on their letter buttons and keeping the Ctrl key pressed. Add up multiple non-adjacent columnsĮxcel allows selecting multiple non-adjoining columns and use the insert column shortcut to get new columns appear to their left.ġ. If you need to add multiple non-adjacent columns, see the steps below. This is how you can effortlessly add several new columns to your table in Excel. Press F4 to repeat the last action or Ctrl + Y to insert new columns. Click on the letter button of the column immediately to the right of where you want to insert the new column. If your task is to quickly insert one column, these steps are by far the quickest and simplest.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |