How To Make An Email Address Clickable In Excel
How do you make an email address in an Excel spreadsheet clickable? To make an email address clickable in a spreadsheet check the format of the cell is not set …
Spreadsheets
If there’s one application I have come to appreciate more and more throughout my career it’s the humble spreadsheet. Without this application, I would be lost.
I use this type of software every day and have been using it since 1995 and Microsoft Excel.
However, since working with Google Apps more frequently I’ve found I tend to do a lot more work with Google Sheets at work than Microsoft Excel. I have found the sharing and collaboration feature with Google Sheets a handy and powerful feature.
Set Conditional Format Based On Another Cell Value In Google Sheets
How can you create a conditional format in Google Sheets based on the value from another cell or column regardless of whether that cell is on the same sheet or …
“We’re sorry, a server error occurred while reading from storage. Error code NOT_FOUND.”
What do you do when you’re running a Google App Script and you encounter the following error in the Execution Log area? Check the libraries you have attached to your …
How To Clean And Format Phone Numbers In Google Sheets
If you’re working with data in Google Sheets you’ll soon come across a time when you will need to clean and format phone number data entries. To clean phone numbers …
Alternatives To VLOOKUP Function When You Want Values To The Left Of VLOOKUP Range
How do you get the value from a column that is to the left of a VLOOKUP range? The VLOOKUP function is a powerful function that enables you to capture …
How To Format Text Like “1st Jan 22” To A Date In Google Sheets
How do you format a cell that contains text like 1st Jan 2022 into a cell that Google Sheets can recognize as a date cell? There are certain types of …
How To Sort By Date In Google Sheets And What To Do When It Doesn’t Work
How do you sort a range containing dates in Google Sheets? Sorting a data set in columns or rows containing date data in Google Sheets can easily be done by …
How To Use The SWITCH Function In Google Sheets?
The SWITCH() function in Google Sheets is handy when dealing with multiple criteria based on a single result. The SWITCH() function takes at least 3 parameters, with the first parameter …
How To Add In Excel: Use + Or A Formula? (Examples)
A spreadsheet helps users to be able to perform calculations without doing this process manually by hand. As you come to use spreadsheets more often you’ll be impressed at the …
How To Separate Characters Into Cells In Excel
If a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to …
How Do You Type A “+” (Plus) In Excel?
When you start entering text into a cell and the first character of that cell is a plus symbol (+) you will get an error #NAME? and you would have …
How To Get Rid Of E+(Number) In Excel
When using large numbers in Excel or any other spreadsheet application, such as Google Sheets, some cells may display a number in scientific notation like 9.991E+35. How do you get …
Why Does VLOOKUP Return #N/A When Value Exists? (Examples)
The VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: …
How To Use Multiple Ranges In QUERY Function: Google Sheets
The QUERY formula is a great way of being able to perform basic SQL-like commands on a data range. The signature of the QUERY formula is as follows: The first …
How To Unmerge Multiple Cells With One Click: Google Sheets
Merged cells are a great way to span content over multiple cells, and you can easily remove a single merged cell with one click by clicking on the merge cell …
How Do You Put Multiple Conditions In One Cell In Google Sheets?
There will come a time when using Google Sheets where you will be checking the value of a cell against multiple criteria, which one is the best to use? There …
Reverse Last Name & First Name With Comma Using One Formula: Google Sheets
Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. …
IF Formula With Multiple Conditions: Google Sheets
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only …
How To Check If Cell Is Empty (Or Not): Google Sheets
How do you check if a cell is empty or blank in Google Sheets? There is a handy function called ISBLANK which enables you to check if a cell is …
What Is The Formula To Calculate Age?
Recently, I had an issue where I needed to calculate the age of a person at specific dates throughout the year. Using a Google Sheet, I thought I could simply …
