Are you tired of the tedious process of inserting lines in Google Sheets? Well, fret not! In this article, we’ll explore an amazing trick that will make your life easier and save you a ton of time. So, let’s dive right in and learn how to use the line insertion trick in Google Sheets on both Windows and Mac.
Inserting Lines Quickly in Google Sheets
We all know how to perform various functions in Google Sheets, but what if we could do it even faster? That’s where shortcuts come in handy. They make your work smoother and more efficient. In this section, we’ll see how you can insert lines in Google Sheets using shortcuts on both Mac and Windows.
On Mac:
Step 1: Open Google Sheets in your desktop browser.
This will serve as the sheet where you’ll be inserting the lines. If you’re already working on an existing sheet, there’s no need to open a new one. The shortcut works well with both options.
Step 2: Select the line or lines around the area where you want to insert more lines.
By selecting a line, you restrict any changes from affecting that line. If you want to modify multiple lines together, select them all. This will significantly speed up your work and avoid unnecessary repetition.
Note: The number of inserted lines will be the exact number of lines you have selected.
Step 3: Use the keyboard shortcut ‘⌘ + option + =’.
In this exemplary scenario, you won’t even need to click or move your mouse before inserting the lines.
Step 4: Select your preferred option from the options provided.
After using the shortcut mentioned in Step 3, several options will appear. Choose the option that best suits your work or the format you desire.
On Windows:
The line insertion trick in Google Sheets on Windows follows similar steps to Mac, but the process differs in terms of the exact keys used on your keyboard.
Step 1: Open Google Sheets in your desktop browser.
Most of the time, you probably already have it open if you’re working on a project in the Google Sheets workspace.
Step 2: Select the number of lines around the place where you want to insert the desired lines.
Remember, the number of selected lines directly affects the number of lines that will be inserted.
Step 3: Use the keyboard shortcut ‘CTRL + ALT + =’.
This shortcut does the same thing as the one on Mac. Both of them offer you options to insert lines in Google Sheets.
Step 4: Select the option that suits you best to insert one or more lines into your document.
Here’s another way to insert lines in Google Sheets using a slightly different set of keys. This method allows you to insert lines above or below the selected lines.
Step 1: Open Google Sheets and select the lines where you want to insert a line.
Step 2: Use ‘Alt + Shift + i + r’ for Windows. For Mac, use ‘Ctrl + Option + i + r’. This will insert the line or lines above or below the ones you selected.
Standard Keyboard Shortcuts in Google Sheets
The following keys serve as shortcuts for different standard functions in Google Sheets. First, let’s look at Windows, and then Mac.
For Windows:
- Select a column: Ctrl + Space
- Select a line: Shift + Space
- Select all: Ctrl + A
- Select all (including empty cells): Ctrl + Shift + Space
- Undo: Ctrl + Z
- Redo: Ctrl + Y
- Redo (including empty cells): Ctrl + Shift + Z
- Repeat the last action: F4
- Find: Ctrl + F
- Find and replace: Ctrl + H
- Fill range: Ctrl + Enter
- Fill down: Ctrl + D
- Fill right: Ctrl + R
- Save (every change is automatically saved in Drive): Ctrl + S
- Open: Ctrl + O
- Print: Ctrl + P
- Copy: Ctrl + C
- Cut: Ctrl + X
- Paste: Ctrl + V
- Paste only values: Ctrl + Shift + V
- Show common keyboard shortcuts: Ctrl + /
- Insert a new sheet: Shift + F11
- Compact controls: Ctrl + Shift + F
- Enable/disable input tools (available in non-Latin language sheets): Ctrl + Shift + K
- Select input tools: Ctrl + Alt + Shift + K
- Tools search (formerly Find in menus): Alt + /
For Mac:
- Select a column: Ctrl + Space
- Select a line: Shift + Space
- Select all: ⌘ + A
- Select all (including empty cells): ⌘ + Shift + Space
- Undo: ⌘ + Z
- Redo: ⌘ + Y
- Redo (including empty cells): ⌘ + Shift + Z
- Repeat the last action: Fn + F4
- Find: ⌘ + F
- Find and replace: ⌘ + Shift + H
- Fill range: ⌘ + Enter
- Fill down: ⌘ + D
- Fill right: ⌘ + R
- Save (every change is automatically saved in Drive): ⌘ + S
- Open: ⌘ + O
- Print: ⌘ + P
- Copy: ⌘ + C
- Cut: ⌘ + X
- Paste: ⌘ + V
- Paste only values: ⌘ + Shift + V
- Show common keyboard shortcuts: ⌘ + /
- Insert a new sheet: Shift + Fn + F11
- Compact controls: Ctrl + Shift + F
- Enable/disable input tools (available in non-Latin language sheets): ⌘ + Shift + K
- Select input tools: ⌘ + Option + Shift + K
- Tools search (formerly Find in menus): Option + /
Best Free Alternative to Google Sheets – WPS Office
Sometimes, you may need an alternative to Google Sheets or Microsoft Excel that offers robust features for your work or project. However, finding tools that meet your requirements can be challenging. That’s where WPS Office comes in.
I highly recommend using WPS Office as an excellent choice for an easy-to-use alternative that gets the job done. It is a powerful office suite with multiple free features, making your project execution a breeze.
Why Use WPS Office?
- WPS Office has built-in word processing, Excel, and a powerful PDF tool, providing you with an all-in-one workspace.
- WPS Office is compatible with MS Office, Google Workspace, and LibreOffice, making it versatile enough to meet all your project needs.
- The lightweight and comprehensive office suite has a rich template store. You’ll always find something that matches your preferences.
- You can choose to work with WPS Office online or offline. Yes, the office suite works seamlessly with both options.
- WPS Office works well on PCs and mobile phones. You can also sync your work across devices and collaborate with others in real-time.
- And the best part? WPS is free to download and use!
Speaking of downloads, follow the steps below to start your work journey with WPS Office for free:
How to Download and Use WPS Office for Free
Browser:
Step 1: Open your preferred browser and visit the official WPS Office website.
Step 2: Click on the “Download” button at the top right of the homepage. Then, choose where you want to save the installation file.
Step 3: Double-click on the downloaded file once the download is complete to start the WPS Office installation process.
Microsoft Store:
Step 1: Open the Microsoft Store on Windows.
Step 2: Search for “WPS Office” in the store.
Step 3: Click on WPS Office among the search results.
Step 4: Click on the “Install” button to start the download.
Step 5: When the download is complete, the “Install” button will change to “Open”. Click on it.
Step 6: Select the “Accept and Continue” option to proceed once the application opens. You only need to do this once.
Step 7: You can now start enjoying all the features of WPS Office.
FAQ
1. How can I add borders to cells in Google Sheets?
You can add borders to cells in Google Sheets by following these steps:
Step 1: Select the cell or cells to which you want to add a border.
Step 2: Click on the “Borders” button and choose the desired border from the dropdown menu options. In the image below, we chose the “All Borders” option.
Google Sheets will apply the selected border option to the chosen cells.
2. Can Google Sheets handle up to 100,000 lines?
While you start with 1,000 lines, Google Sheets can handle over 100,000 lines. You can go up to 10,000,000 lines for your project.
However, you need to stay within this maximum line limit.
Summary
In this article, we showed you an easy way to use the line insertion trick in Google Sheets for both Windows and Mac, as well as several shortcuts for standard processes in Google Sheets.
But wait, there’s more! You now know about an excellent alternative to Google Sheets and Microsoft Excel, which is WPS Office.
WPS Office offers a powerful office suite with multiple features and templates. The tool is highly compatible and works well on all platforms and devices. You can start with all its features by following the steps in this article.
So, what are you waiting for? Try out the line insertion trick in Google Sheets and explore the wonderful world of WPS Office for all your work needs. Visit Crawlan.com to learn more about boosting productivity with tech hacks.
