Solve software problem quickly Share experience to help others Improve the ability of solving problem
How to Insert a Static Time in Excel

11/15/2011 07:22 by maxkitty

First answer posted by Bentley907 at 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
1 Answers
  • Bentley907
    1. Start Microsoft Excel 2007, and open an existing workbook from your files in which you want to insert a static time into one of the cells. Alternatively, you can start a new, blank workbook to insert the static time.

    2. Select the cell in the workbook you want to insert the static time into by clicking on it. The selected cell will now have a thick black box around it, indicating that it is selected and ready for the next step.

    3. Hold down the "Ctrl," "Shift" and ":" keys at the same time on the keyboard. This keyboard shortcut will instruct Excel to enter a static time into the selected cell.

    4. Look at the cell, and see the current time to be inserted into the selected cell. This time will not change at any point unless you manually change it yourself. It will not update on its own at any time.

    5. Insert the static time into any other cells in the open Excel workbook using the same procedure that is outlined in the previous steps.

  • Was this answer helpful? 00 · 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:Can Someone Introduce Microsoft Excel 2007 for Me?

A:Since Excel 1995, Microsoft Office Excel has been the dominant spreadsheet application used in businesses, college campuses and most homes. It...(more)

Q:How to Get a Random Sample in Excel

A: Start Microsoft Excel 2007 and open a workbook from your files that contains data you want to use to get a random sample. Verify that colu...(more)

Q:How to Filter Data in Microsoft Excel 2007

A: Select the Home Tab on the Ribbon. The Ribbon is the group of icons and tools located directly above the work area. Locate the Editing Gro...(more)

Q:How to Create a Scatter Plot in Microsoft Excel 2007

A: Open the Excel spreadsheet that you want to add a scatter plot graph to. Arrange the data that you want to use to create the scatter plot....(more)

Q:How to Add Shapes to a Character in Microsoft Excel 2007

A: Start the Microsoft Excel 2007 program. Click the "Insert" tab near the top of the Microsoft Excel 2007 window. Choose "WordArt," which ...(more)

0 people are following

Ask a question now
Write a title for your question

Microsoft Excel Viewer 2003

open, view, and print Excel workbooks, even if you have example excel formula.
Latest version:1.0
OS:Windows 2003,Windows XP,Windows 2000
Total downloads:445,228
Rank:1 in Spreadsheets
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!


Are you sure to delete your answer?



Are you sure to choose it as the best answer?



Voted Successfully!


You can't vote for yourself


You can't choose your own answer