Results 1 to 9 of 9

Thread: Tabs in excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Tabs in excel

    Hi,

    my case is to create a tab in excel sheet.

    eg: there are column1,column2,column3, I want to create a tab which when i click should highlight only the values in column 1,similar another tab should highlight only values in column 2

    Please someone help me out on this.
    thanks,

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,319
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Sorry, I'm not really following what you're asking here...
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Ken,

    I want to create a button in excel sheet that links/highlights only a particular row when i click on the button.


    Here in this case when i click button P1 it shoudl highlight only P1 and similarly for P2 & P3
    Click image for larger version. 

Name:	2012-12-21 12-32-34_Microsoft Excel - Book1.gif 
Views:	26 
Size:	10.4 KB 
ID:	983
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	untitled.GIF 
Views:	19 
Size:	15.2 KB 
ID:	982  

  4. #4
    Also can u please can provide me the detaisl on how to animate an object in excel. like movign forth horizontaly and vertically

    Please help me out.

    thx,

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,319
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Let's start with the first question first, and come back to the second one.

    So those areas you want to highlight... are they some kind of textbox or shape? Or are you trying to select specific ranges of cells? (Like selecting A1:A10 for example)

    What colour do you want them to be? And what version of Excel are you using?
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    Ken,

    Its a specific range of cells.I want them to be in any colour.My version of excel is 2003.

    thx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •