"There is nothing like looking, if you want to find something. You certainly usually find something, if you look." ― J.R.R. Tolkien, The Hobbit
Welcome to Ablebits blog!
My name’s Natalia, and I’m a happy member of Ablebits team – people who work hard every day to create wonderful tools to simplify your day-to-day experience with spreadsheets.
Recently, I've been taking pleasure in translating books and videogames – things that make our pastime merrier. And to make your work joyful as well, allow me to be your humble guide into the world of useful Google Workspace add-ons. After all, they do help to solve a great deal of tasks in your files faster and easier. :)
May the add-ons be with you ;)
Here is a list of Natalia's recent articles:
How to create & edit Google Sheets formulas: key functions and examples
How to merge cells in Google Sheets without losing data
How to delete empty rows & cells in Google Sheets
How to sort in Google Sheets: tips, techniques, best practices
Beyond words: comprehensive guide on styling text in Google Docs
How to make a good-looking table in Google Sheets
Styles for Google Docs – V2.0. What's new?
All Google Docs & Google Sheets limits you need to know
Version history in Google Sheets: see edit history & restore any version
Merge Google sheets: update cells, add related columns & non-matching rows
How to merge Google sheets: lookup, match and update records
How to highlight duplicates in Google Sheets
How to find and remove duplicates in Google Sheets
How to split Google Sheets into multiple sheets or files
CELLCOLOR & VALUESBYCOLORALL: functions for Google Sheets to work with colored cells
Find and replace Google Sheets data and special characters
Extract data from Google Sheets cells: text, numbers, URLs, hyperlinks, email addresses, dates, and time
Google Sheets: remove the same text or certain characters from multiple cells at once
Add text to multiple cells in Google Sheets at the same position
How to change case in Google Sheets: UPPER, lower, Capitalize Each Word, Sentence case, tOGGLE
Count words and characters in Google Sheets: LEN function
Calculate days, months and years between two dates in Google Sheets: DATEDIF formulas
INDEX MATCH in Google Sheets – flexible Vlookup for your spreadsheets
Google Sheets QUERY function: a spreadsheet cure-all you have yet to discover
Google Sheets FILTER function: formulas and tools to filter data in spreadsheets
How to insert Google Sheets checkmarks and cross marks
Must-know Google Sheets functions not available in Excel
How to merge several Google sheets into one without copy-pasting
How to change Google Sheets date format and convert dates to numbers and text
Google Sheets CONCATENATE function to combine text from cells
Google Sheets percentage formulas - usage and examples
How to compare data in two Google sheets or columns
Merge data from duplicate rows in Google Sheets based on a unique column
Convert formulas to values in Google Sheets
How to split cells in Google Sheets
Calculating time in Google Sheets: subtract, sum and extract date and time units
How to capitalize first letter in Excel cells
How to add, use and delete checkboxes in Google Sheets
Video: Conditional formatting based on another cell
How to count colored cells in Google Sheets