Extend Spreadsheet Title For Free

in Google sheets every project is different that means you may want to modify certain things including the size and layout of your cells to better fit the data you're working with for example this column has already been resized but not quite enough a couple of the addresses are still getting cut off I'm going to increase the width a little bit more by positioning my mouse over the line in the column heading then clicking and dragging it to the right another option is to auto size the column this will automatically adjust the width so it fits the contents of the cells exactly just double click the line instead of dragging it now the column is perfectly sized to the text rows work very much the same way they start out auto size to fit your text but you can easily adjust their height by clicking and dragging the lines sometimes it's useful to be able to resize all of your cells at once for example in this spreadsheet I'd like to make all of my rows the exact same height to do this click the Select All button just below the formula bar then resize a row it doesn't matter which one and the change will be applied to the entire spreadsheet next I need to add another row to this list I'd like to put it in between row 6 and row 7 to add a new row all you have to do is right-click then choose from the menu the process is similar for adding a new column again just right-click then make your selection deleting columns and rows is easy first select the column or row you want to delete then right-click and choose delete column from the menu if you need to move a column or row start by selecting it then drag and drop it into place let's fast forward to the finished spreadsheet next I'd like to take a look at wrapping text which is one of the ways of addressing cells that contain more text than they can actually display for example I'd like to resize my column of addresses to about half its current size but still be able to see the contents we can do this by using the wrap text button on the toolbar now the text is on multiple lines another useful feature for spreadsheets with lots of data is the ability to freeze certain rows or columns it works just like it sounds the cells become frozen or fixed in place allowing you to scroll through your spreadsheet and still see important information like your header row to get started open the View menu select freeze then choose the option you want in this example I want to freeze the first two rows the title and the header so I'm going to choose two rows now the top two rows will stay in place when I scroll through the rest of my spreadsheet a thin gray line indicates where the cells are frozen now for the finishing touch combining the cells in the top row so the title of my spreadsheet can be centered in single large cell to do this select the cells you want to merge then click merge cells on the toolbar there that's perfect the best way to learn about modifying cells freezing rows and columns and wrapping text is to...