Modifying Worksheets
After you put up the signposts that make your data easy to find, you can take other steps to make the data in your workbooks easier to work with. For instance, you can change the width of a column or the height of a row in a worksheet by dragging the column or row's border to the desired position. Increasing a column's width or a row's height increases the space between cell contents, making it easier to select a cell's data without inadvertently selecting data from other cells as well.
Tip
You can apply the same change to more than one row or column by selecting the rows or columns you want to change and then dragging the border of one of the selected rows or columns to the desired location. When you release the mouse button, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access