When you have a lot of text in one of the cells of your spreadsheet you may find that you can’t see all of it. While you might have tried ot resize the cell or manually insert line breaks, you can also use an option that will cause the text to “wrap.” Our guide below… Continue Reading How to Wrap Text in Google Sheets
Cell shading is an effective way to draw attention to data in your spreadsheet without having to modify the actual data itself. But you may have a cell to which you have previously applied a fill color, only to find that the data has changed, or that the formatting of the document dictates the removal… Continue Reading How to Remove Fill Color in Google Sheets
When you need to make the cells in your spreadsheet taller you will find that the data in those cells is displayed at the bottom of the cells. This isn’t obvious when you are using the default cell heights, but it may not look the way that you want it to. Luckily you are able… Continue Reading How to Vertically Center Cell Data in Google Sheets
One of the best features about working with Google apps like Google Sheets is how well they work when you are doing online collaboration. But occasionally you will need to create a file that you can share with other people, such as those who aren’t able to work in the Google Sheets app on their… Continue Reading How to Convert a Google Sheets File to a PDF
As a Google Apps user, it is really easy to share and collaborate on spreadsheet files with other people that also use Google Sheets. But not everyone is using those applications, and you might need to download Google spreadsheet files into other file types to share them with non-Google users. One of the more common… Continue Reading How to Download a Google Sheet as an Excel File
The Google Sheets application has a lot of different tools to customize the appearance of your cells. But perhaps one of the most useful ones allows you to darken the lines that separate your cells. Our tutorial below will show you how to add borders in Google Sheets if you want to make these lines… Continue Reading How to Add Borders in Google Sheets
Finding data within a large spreadsheet file can be tedious, if not impossible. Fortunately, you have some options when you are trying to figure out how to search in Google spreadsheet files that can make the whole process a lot simpler. How to Search a Spreadsheet in Google Sheets Open the spreadsheet. Press Ctrl +… Continue Reading How to Search in Google Spreadsheet Files (An Easy 3 Step Guide)
The formatting that you apply to information in a document or a spreadsheet can be just as important as the information itself. Whether this is the font, the document margins, spacing after paragraphs, or the alignment, using the right formatting can make your data easier to read, and more visually appealing. If you want to… Continue Reading How to Indent Text in Google Sheets
There are a lot of tasks that someone might perform manually in Microsoft Excel or Google Sheets before they realize that there is a way to accomplish what they want alphabetically. I have seen people that had a list in the application that they needed in alphabetical order and, instead of using the tool built… Continue Reading How to Alphabetize on Google Sheets
Spreadsheet applications like Microsoft Excel and Google Sheets provide you with options to create a merged cell. This is a useful option when you need to make a cell that is larger than the rest of the cells in your spreadsheet. If you need to unmerge a single cell or unmerge multiple cells in Google… Continue Reading How to Unmerge Cells in Google Sheets