Excel Problem??

the only way i know how is like this:

lets say you want to measure A1.

you could click the line to the right of the A up at the top (where it says A B C D E...) and then write that down, then measure the line below the 1 on the left menu.

or you can just click the cell you want to measure and go Format > Row/Column height and it will say it there :)

Click on Format>Column Width or Format>Row Height. The measurement of the selected cell is displayed in this box and from here can be adjusted.

Also if you place your mouse to the right of each cell in the top row that contains the column letters, it will turn into a cross, if you now left click, the column width is displayed. It's the same for rows.

Hi there.

To do this precisely you should use VBA. To get into VBA press Alt + F11. If you then type Ctrl + G you will open the immediate window, from which you can run VBA code on the fly.

? activecell.Height

12.75

? activecell.Width

48

shows the results for a default cell

? activecell.Height

27

? activecell.Width

92.25

shows the results after the cell has been randomly resized

Have fun :)

If you go to the edge of the gridlines, click and drag you can adjust the size and it should show you as you do this what the measurement is, can deffo do this on width, not too sure about height but I think you can !

yes, but must be done seperately.

For height, right click on the cell number and select 'Row Height'

For width, right click on the cell letter and select 'Column Width'.

Hope that helps!

Do you really mean row height and column width? Right button of mouse on row height will give you the default which I think is 12.75. Right button of mouse on column address down to column width, the default being 8.43, therefore your default cell woudl be 12.75 x 8.43.

Right click on the row or column you want to know about (the letter or number of the column or row). Then just click on "row height" or "column width".

Well it depends. Remember these are spread sheets. Also are you refering to the 'cells'? Well the sizes can be changed and re set. So it all depends on what you are trying to do. Use a tape measure and measure the size of the cells on your screen. No idea other wise.

It will only do that if the a1 is replaced by $a$1 i.e. becomes an absolute reference. The way you have done it will have the formula in A3 referring to A2, the formula in A4 referring to A3 etc because A1 is automatically updated when you click and drag. $A$1 is an absolute reference and will always refer to the contents of A1 whether you drag it down or across the spreadsheet