To move from one sheet to another

927 views 9 replies

Hello Everybody from today we will learn everyday one shortcut key of EXCEL'

1.To move from one sheet to another?

Press ctrl+pgup and ctrl+pgdwn

Replies (9)

converting formula in values:

when we have used a formula to calculate some figures, now we need to use these figures in other working sheet independent of current working. convert these formulas into value as follow:-

 

Copy the all the cells, which u want to convert

go to cells where u want to put the values of these cells

go to edit menu

go to paste speciat

chek on the values

ok

 

 

Thanks Sonia  for sharing

what is the short cut key to delete a row?

wat is the short cut for totalling amount in a column.

to delete the row or column

 

select entire row or column

 

and then press "-" with CTRL.

Nice..

Thanks

What abt inserting & sum shotcuts

Originally posted by :J.N.Ansari
" wat is the short cut for totalling amount in a column. "

just press Alt  plus =           on the bottom cell of the column

when u need to write some text in a single row, and start next para in the same row:

 

press ALT plus Enter instead of Enter.

 

Some useful excel tips in the attached file.

 

Anand

9922941938


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register