
100 Top Tips: Microsoft Excel
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
See how to quickly insert multiple rows or columns in your Excel spreadsheet. By Sean McManus, from the book 100 Top Tips: Microsoft Excel
I'll show you how to quickly insert multiple rows. You can use a similar technique to insert columns.
Click the number of the row where you want to insert above, and drag down for as many rows as you want to insert. For the example here, I want to insert three rows above row 4.
Click Insert in the Cells group of the Home tab. You could alternatively use Ctrl with the plus symbol (+). You can use the + key on your number keypad or add Shift to the key combination to use the key on the main keyboard.
If you're inserting a row to copy another row into it, you can save time by copying the row first. When you insert, your copied row will be pasted into the new row(s).
This tutorial is from 100 Top Tips: Microsoft Excel. The powerful pocketbook helps you to learn more from your data, be more productive with Excel, and improve the accuracy of your spreadsheets. It's packed with shortcuts, tips, and hacks for Excel that solve everyday business problems. Find out more and download a free PDF sampler here, and order the book online here.
© Sean McManus. All rights reserved.
Visit www.sean.co.uk for free chapters from Sean's coding books (including Mission Python, Scratch Programming in Easy Steps and Coder Academy) and more!
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
This book, now fully updated for Scratch 3, will take you from the basics of the Scratch language into the depths of its more advanced features. A great way to start programming.
Code a space adventure game in this Python programming book published by No Starch Press.
Discover how to make 3D games, create mazes, build a drum machine, make a game with cartoon animals and more!
Set up your Raspberry Pi, then learn how to use the Linux command line, Scratch, Python, Sonic Pi, Minecraft and electronics projects with it.
In this entertaining techno-thriller for adults, Sean McManus takes a slice through the music industry: from the boardroom to the stage; from the studio to the record fair.