Tuesday 26 September 2017

Hyperlink a specific excel table to any document


  1. Create table with headers in excel .
  2. Name the table by- Formulas - Name manager - New - Name - save .
  3. Select the word to be hyperlinked - insert - hyperlink - select - source excel file .
  4. at the end of excel files name write #"table name".
  5. Save . Done 

Monday 11 September 2017

Adding multiple uniform blank rows in excel sheet





Adding image in proper Size in blogger post -


Step 1. go to dashboard -- theme---customise--- Advanced --- Add CSS - paste following code --
.post-body img {
max-width: 100%;
max-height: auto;
display: block;
margin: auto; 
}

Save by Clicking " apply to blog"

 Step 2 . Always select " original size " after uploading the image on blogger .

Done .

Ambadnya. 

Wednesday 6 September 2017

Adding Specific Excel (any other ) File Shortcut To Win 8 Taskbar

Create new shortcut on desktop ; properties - path - add " explorer " word and space before path ; save ! then pin this shortcut to taskbar .

Ambadnya !