#14 - The Sheet 📃
Adding rows 🚣♀️ and columns 🏛️
Hey Friends,
Welcome back to the Sheet! It’s a short one this week
📋 Summary:
💡 The Sheet Tip (Add / Remove Rows and Columns)
🫵 I have a favor to ask…
=💡 The Sheet Tip (Add / Remove Rows and Columns)
Many Excel users right-click their mouse to add or remove rows/columns in Excel. Whilst there is nothing wrong with using the mouse, if you are tidying up a spreadsheet and repeating this task frequently, right-clicking can become quite time-consuming.
To save time, try doing this instead:
Select the row using the shortcut SHIFT + SPACE
To add a row use the shortcut CTRL + SHIFT + PLUS (+)
To remove the highlighted row use the shortcut CTRL + SHIFT + MINUS (-)
Note, you can do the same with columns. Simply select the column of interest using the shortcut CTRL + SPACE
🫵 I have a favor to ask…
Many people have asked if there's a way they can "give back" to Functional Excel. Normally the answer is no, just keep using Excel to crush it!
But today, I DO have something to ask...
We have ambitions to expand our service offering to better help YOU level up your Excel game. Think online courses to help you finally master Excel as well as high-quality free resources (workbooks, formula guides, etc.).
BUT before we can do this we need to continue to grow our fantastic community. To do this we need your help! Word-of-mouth can make a world of difference.
And so...if you'd like to help promote ‘The Sheet’ hit that share button below.
As always, thanks for reading.
See you next week.
The Functional Excel Team