CA Ravindra Patil

Techno-Tip #7 by CA Ravindra Patil (92093-00789)                         (17-03-2018) Protect a word document and mark the parts that can be changed in Word 1. On the Review tab, in the Protect group, click Restrict Editing. 2. In the Editing restrictions area, select the Allow only this type of editing in the document              check  box. 3. In the list of editing restrictions, click No changes (Read only). 4. Select the part of the document where you want to allow changes.      Tip: To select more than one part of the document at the same time, select the part that you want, then press CTRL and select                 more parts while you hold down the CTRL key. 5. Under Exceptions select the Everyone check box in the Groups list. 6. Und...

_Techno-Tip #6 by CA Ravindra Patil (92093-00789)                        (10-03-2018)_ *Cell Reference in Excel* 1. Excel has a cell reference style C1R1     Where C1=Column 1 & R1=Row 1 2. When we drag/copy and paste the formula cell reference also change automatically.      e.g. C1=A1+B1, if we copy cell C1 & paste in cell F5 formula will change to D5+E5 it’s called              relative reference 3.  If you want to make the cell reference as absolute reference (means reference will not change             with drag/ copy & paste) we have to assign $ sign to column & row label      e.g. C1=$A$1+$B$1, here if you copy formula of cell C1 & paste in F5, formula in cell F5 will             ...

Techno-Tip #5 by CA Ravindra Patil                          (03-03-2018) Keys and Shortcuts Keys for Fast Navigation in Excel 1. Arrow Keys = move up, down, left & right 2. Page up/down = go one page up/down in same sheet 3. Alt + page up/down = go one page left/right 4. Ctrl + Arrow Keys = go to end of continuous range 5. Ctrl + Page up/down = Go to previous or next sheet 6. Shift F11 = insert new sheet 7. F5 = go to specified location (either cell reference/name) 8. Ctrl + [ = trace precedent 9. Ctrl + ] = trace dependent 10. Ctrl + F3=Name Manger =Apply name to selected range. 11. Home = go to first cell of selected row. 12. Ctrl + Home = Go to first cell of Sheet 13. Ctrl + end = go to last edited cell in sheet Tip: Use Shift with above combinations for selection