Hello everyone, welcome to Learn Tech Tips blog, I am Zidane, Hope you well, Thanks for enjoy my blog sharing experiences. Before enter topic Please give a like, subscribe and share to your friend for get more tips everyday.
Today I will update some new function ON GOOGLE SHEET, I think that is a best tips can help and support you easy to complete your daily work! ok, Don’t waste your time now, let get started!!!
First I need to introduce you a FUNCTION for change color or turn a dull spreadsheet into a rainbow coloured on Google Sheet.
Typing ‘PRIDE’ across the first rows in a spreadsheet, Google sheet coveted Easter Egg turns a dull spreadsheet into a rainbow coloured
PRIDE, KEYWORD for change the color on each columns on Google sheet
Sometime you want to add some color to your Google sheet for make it easy checking, I can suggest you one keyword is PRIDE, You just can type the below ‘P R I D E’ on each Columns: A, B, C, D, E (each column one character) => The color will auto show on same as below screen shoot. Is it cool.
Enjoy with PRIDE
After understand how to use PRIDE, now we continue go through next tips for auto increment number
Most of work on Excel, Google Sheet, you will type the auto increment number, On this continue tips, I will share with you a SEQUENCE function
SEQUENCE – Make your auto increment number easily
The SEQUENCE function returns an array of sequential numbers, such as 1, 2, 3, 4, 5, 6, …
This Function include 4 parameters: rows, columns, start, step
rows: REQUIRED, The number of rows to return
columns: Optional. The number of columns to return. If omitted, the returned array will have one column
start: Optional. The number to start the sequence at. If omitted, the sequence will start at 1
step: Optional. The amount to increase/decrease each number in the sequence. If omitted, the sequence will increase by 1.
Example:
SEQUENCE(1, 8, 1, 1) – auto increment 8 number on 8 columns
Example:
SEQUENCE(10, 1, 1, 1) – auto increment 10 number on 10 rows
Reference link
Do you enjoy above two tips: PRIDE and SEQUENCE Function (Please be note: that just available on Google sheet right now, hope on future will available on Microsoft Excel too).
You can follow my video here for easily do it.
@learntechtips How to turn your dull spreadsheet into a rainbow and make auto increment number. Google sheet Tips #learntechtips #googlesheettips #learnontiktok ♬ nhạc nền – KEN vLoGs
Another Excel tips here, you can check it if you love it
Hope you enjoy my sharing experience. If you have any question, free feel leave your comment on below topic, we can discuss about it
Learn Tech Tips
Zidane