Cell Manipulations (Mac)

Entering Data

To enter data into a cell, simply type it in. When you type into the cell, the information will also be visible in the formula bar.

https://library.barnard.edu/sites/default/files/images/inline/data_1.gif


Use the arrow keys to move from cell to cell. Also, pressing ENTER will move to the cell below and SHIFT+ENTER will move to the cell above. Pressing TAB will move to the right cell and SHIFT+TAB will move to the left cell.    

If your mouse has a scroll wheel (the "third" button) you can use it to scroll up and down the spreadsheet (but not change which cell you are typing in). When you hit the SCROLL LOCK key (if your keyboard has one) you can use the arrows to scroll up, down, left, or right (but not change which cell you were typing in). 

 

Selecting Cells

There are many ways to select cells in a worksheet.

1. Use the mouse to select a range of data cells. Click on the cell in one corner of the range and holding down the mouse key, drag the mouse until all cells in the range are highlighted.

2. Select the cell in one corner of the range and while holding down SHIFT, either use the mouse to click on the cell in the opposite corner to mark the range, OR use the arrow keys to highlight the cells. 

https://library.barnard.edu/sites/default/files/images/inline/select.gif

 

Selecting Non-adjacent Cells

To select cells that are not next to each other, click on the first desired cell (or range of cells), and then while holding down Command, click on the other cell (or range of cells). As long as you hold the Command key down you can continue selecting non-adjacent cells. However, not all functions can be performed on multiple cells (e.g. Paste).

https://library.barnard.edu/sites/default/files/images/inline/cellselect.gif

 

Selecting Rows or Columns

To select an entire row, click on the number of the row with the mouse. This will select all cells in the entire row (all the way to XFD). Holding down the mouse key you can also highlight multiple rows by scrolling down the numbers.

https://library.barnard.edu/sites/default/files/images/inline/rows.gif


Selecting columns works in the exact same way except that you replace numbers with letters.

As with cells, you can highlight non-adjacent rows by pressing Command and clicking on the numbers of the rows/columns that you want to highlight.

https://library.barnard.edu/sites/default/files/images/inline/columns.gif

 

Selecting the Entire Worksheet

Press Command+A and all of the cells in the worksheet will be highlighted. You can also click on the top left corner of the worksheet (directly above the 1 and directly to the left of the A). 

 

Changing the size of cells

Select the rows, columns or range of cells that you want to change the size of (note that changing the size of a range of cells will automatically change the size of the entire row(s) and/or column(s), not just the selected range). Go to Format in the Cells category under the Home tab.

https://library.barnard.edu/sites/default/files/images/inline/rowheight.gif


When you click on Row Height (or Column Width) a dialogue box opens with the current row height (or width) where you can type in the new height (or width).

https://library.barnard.edu/sites/default/files/images/inline/changesize.gif


All of the selected rows (or columns) will change. 

You can also change the row height (or column width) with the mouse, but you must select either columns OR rows, NOT a range of cells. After selecting the columns (or rows) you can scroll the mouse over the column letters (row numbers) and the cursor will change to look approximately like this when it scrolls over the borders between columns (or rows):

https://library.barnard.edu/sites/default/files/images/inline/autofit.gif


Holding down the mouse (or clicker) you can drag the column (or row) to be the width that you want. You can also double click on the double arrow cursor and the columns will automatically fit to the size of the contents in the cells. All selected columns (or rows) will be changed.

AutoFit Column Width is also an option under Format in the Cell category under the Home Tab and will do the same thing.

https://library.barnard.edu/sites/default/files/images/inline/autofit2.gif

 

Making Numbers Visible

Sometimes in Excel you'll get this:

This happens when the size of the number is wider than the width of the cell. You can format it by using the methods described above and then

You will be able to see all of your numbers!

 

<< Back to the Ribbon                   Continue to Formatting Cells >>

 

Return to Table of Contents

 

Questions, comments, concerns?
Send an email to the Empirical Reasoning Lab  
Or drop by during the Lab's open hours.