Solved

Quick Access Toolbar Icon Not Working

Posted on 2016-08-16
7
71 Views
Last Modified: 2016-08-18
I went into the Quick Access Toolbar commands and added Current Date and Current Time to the toolbar.
However, I don't see how to use them. They are grayed out.  

Add Current Time
Add Current Time
No date or time added.
0
Comment
Question by:Alex972
  • 3
  • 2
  • 2
7 Comments
 
LVL 16

Expert Comment

by:Brian Pringle
ID: 41758472
That only works if you are in a header or footer field.  Go to the "Insert" tab and then "Header & Footer".  Then, you can insert it.
1
 
LVL 3

Expert Comment

by:Donna
ID: 41758482
Items are typically grayed out when that option isn't available on that particular screen. Do you have a spreadsheet or workbook file open? Open for editing?

Never mind...I read the question wrong...the above answer is correct...this is the header/footer time feature you have on the quicklaunch bar...there is another one for all the date/time formulas, if you want it. just edit your quicklaunch bar. (and use the "all commands" on the "choose commands from"  filter  to see it )
0
 
LVL 1

Author Comment

by:Alex972
ID: 41758540
That doesn't work either.

Header
Icons Grayed Out in Header
Footer
Icons Grayed Out in Footer
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 16

Accepted Solution

by:
Brian Pringle earned 500 total points
ID: 41758544
Not through the page layout options.  You have to be in that "view".  Go to the "Insert" tab at the top of the ribbon, then click on "Header & Footer".
0
 
LVL 1

Author Comment

by:Alex972
ID: 41760256
Thanks, that worked. That's great.  Where would that be documented?
0
 
LVL 3

Expert Comment

by:Donna
ID: 41760272
in most programs nowadays the buttons change depending on the need...whether the reference is to a file, a single document, a part of the document (header/footer) ...the available buttons change. It's kind of common knowledge...
0
 
LVL 16

Expert Comment

by:Brian Pringle
ID: 41760933
I don't know where it is officially documented, but the closest I have been able to find is to go to the "Help" icon and search for "grayed out".  I found an article called "Video: I can’t use the commands on the ribbon", which talks about why they may be grayed out and not useable.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question