Showing posts with label Microsoft Office. Show all posts
Showing posts with label Microsoft Office. Show all posts

Saturday, March 31, 2012

Do you want to save time while creating reports in excel?


If your excel report consists the repeated data in many/all the sheets, don’t think about the copy and paste method we have something very interesting alternative.

Legacy way: Copy the required field and paste in all other required sheets.

Tuesday, March 27, 2012

How to record excel editing's in word document

Some times we need to create a word document which replicates the excel worksheet, there no need to create a table again and fill the data in word document, just do the below 

  •  Copy the required portion in excel template.
  • Open word document and choose paste special option in the paste sub menu item.
  • Select the Paste link radio button and select Microsoft Excel Worksheet Object, then click OK.



Now your word document keep updating as excel template updates.

Saturday, March 17, 2012

keyboard short keys

Few Keyboard shot keys to make work easier.
Open the Run command and type the given command to get the result.

%allusersprofile%                      = shows all users profiles.
%programfiles%                        = opens program files menu.
control desktop                          = opens desktop properties box.
osk                                               = onscreen keyboard.
pbrush                                         = paint.
regedit                                        = registry editor.
taskmgr                                      = task manager.
timedate.cpl                               = opens calendar.
write                                            = wordpad.
utilman                                        = utility manager.
winver                                         = windows version.
appwiz.cpl                                 = opens add/remove folder.
shutdown                                   = shut downs the system.
excel                                          = Microsoft Excel (If Installed)
msaccess                                 = Microsoft Access (If Installed)
powerpnt                                  = Microsoft PowerPoint (If Installed)
winword                                    = Microsoft Word (If Installed)
notepad                                    = Notepad
wordpad                                   = WordPad
calc                                           = Calculator
mspaint                                    = Microsoft Paint