Jan 24, 2023 Google Products

Google Sheets Tips and Tricks for Bloggers

Google Sheets Tips and tricksPin

I am using Google Sheets (Excel) to Calculate monthly income and Maintain client, top blog post details. The following methods, tricks, and shortcut keys helped me to work with Google Sheets very fast. If you are a blogger this article will be useful for you.

If you want to add, maintain your income in Google Sheet

Google Sheet Income bloggerPin

Total amount formula (Vertical)

sheets auto sum formulaPin

To calculate vertical column values, enter the following formula in a new column.


Total amount formula (Horizontal)

To calculate horizontal cell values, enter the following formula.


How to Insert a Comment

Select the cell and press the following shortcut key.

Ctrl+ Alt+M

Other Method: Right-click the cell and choose comments

SEE ALSO: How to Strikethrough in Google Docs (Simple Way)

How to Hide/Wrap text-overflow in Cells

When you enter long URLs or product lists and that text overflows the cell, then use the following method.

Google Sheets clip, wrap, overflow textPin

Apply Clip effect via Toolbar -> Text Wrapping -> Clip.

Shortcut key: You have to press 3 Shortcut keys to apply the “Clip” effect.

  1. Alt + O
  2. Alt +W
  3. Alt+C

Note: If you increased cell height and you want to warp the extra text, apply the “Wrap” effect in Text Wrapping.

Related Tutorial: Microsoft Excel

How to Sort Names in Alphabetical order in Excel

Today we are going to learn “How to sort Names Alphabetically in MS- Excel. And I'm having a few easy ways to do this.

1. Arranging Names Alphabetically

  • Open Ms-Excel and select the column with the name list.
  • Next, tap on Data and in Sort & Filter choose an option to sort your name list.
  • Or else you can see this option on the Home page at the top right corner.
Arranging Names AlphabeticallyPin

2. Arranging Names with details Alphabetically

At times, when you sort the names Alphabetically the details may mess up. But don't worry I'm here to sort that with ease.

Arranging details AlphabeticallyPin
  • Select the column with the name list and click on the options as said above.
  • Now you could see a pop-up “Sort Warning” message. From that choose “Expand the Selection” and tap on Sort.
Sort warnigPin
  • Then a dialogue box will appear, change the settings accordingly and tap on OK.
  • This helps to sort out the names and details correctly.
change settingsPin

Now let me tell you how to split a single row into different columns and make those columns into different rows.

1. Split Single Row into different Columns

  • Select the row and tap on Data -> Text To Column option.
  • From the pop-up wizard, select Delimited and then tap on Next.
Split row into columnsPin

Next, select a Delimiter from the list and hit Finish to complete the process.

Select a DelimiterPin

2. Split different columns into different Rows

Split Columns into rowsPin
  • After completing the process, copy the columns by pressing ctrl+c.
  • Then tap on a box and press ctrl +Alt + V or right-click on the mouse and tap on Paste Special. Then choose Transpose and tap on Ok.
  • Now the columns will be split as rows.

Share to...