can't select a large range of empty cells in a column of a - Microsoft Community

hello,

i'm using latest version excel ( office 365) 15.39,   on mac latest version of safari. 10.12.6. ( not high safari)

   i have spreadsheet 8000 rows. 

i'm unable select cells in 1 column of worksheet.  they empty, other rows or columns have data. 

i want fill down or paste formula, can't  find easy way select cells.  i can move bottom of table, not select cells. 

command + down arrow works in other columns go end of worksheet, there data in it, , command +shift + down arrow selects cells, there data in them.    the files, said should able select cell,  say c2, put new cell id , c8000, in "cell id " box left of function , edit items @ top of spreadsheet, , hit shift + enter , select cells bottom of spreadsheet, column, doesn't work.   

i don't want manually scroll down  for thousands of rows find bottom of worksheet select cells, paste or fill down, 

there must way ??

any ideas appreciated

thank you 

assuming have proper table 1 row of headers (column names) no empty rows or columns (empty individual cells ok), , no merged cells there @ least 2 ways accomplish task.

in both examples follows selected columns b,c , d dragging on column letters , pressed command-1 format cells. on number tab chose currency, 2 decimal places excel knows kind of data have. should format numeric columns appropriate data.

in first example added column label in d1. in cell d2 entered formula shown in screen shot. after entering formula, lower right corner of c2 becomes + sign when mouse held on special spot. double-click while cursor + sign , formula copy down bottom of data range.

a little fancier, click data range , go insert tab of ribbon. click table button turn data range excel table. once converted excel table, cell right of of header row becomes special. following example above, when enter label column d in d1, entire column adopts table formats, , cell under header d2 becomes special cell.

in d2, enter = sign click cell b2 press + sign on keyboard , click cell c2 , excel builds formula using column labels instead of cell references. when press enter enter formula, automatically fills down without having steps. procedure called adding calculated field.

Office / Excel / Mac / Office 365 for business