Question about Microsoft Computers & Internet

1 Answer

Excel Real-Time How to display current real time on Excel without having to refresh while the spreadsheet is open?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 11 Answers

  1. open ur spreadsheet from your files that you want to insert a dynamic date and time
  2. select the cell into which you want to insert the dynamic date and time.
  3. Type "=now()" (ignore quotation marks) into the selected cell.
  4. Press the "Enter" key on your keyboard to enter the formula into the selected cell. You will now see the current date and time appear in the cell you typed the formula into. (Date and time will update every time the "Enter" key is pressed )
.

Posted on Mar 05, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

When i open an excel spreadsheet, the columns go right to left instead of left to right.


  1. Click Options on the Tools menu, and then click the International tab.
  2. Do one of the following in the Right-to-left option group.
    • Click Right-To-Left to have new objects displayed in a direction familiar to right-to-left users.
    • Click Left-To-Right to have new objects displayed in a direction familiar to left-to-right users.

Nov 10, 2013 | Microsoft Excel 2010

1 Answer

How to open excel sheet in different window?


While one spreadsheet is open in Excel, open the second spreadsheet as follows:

Go to Start, Programs, Excel (or however you navigate to Excel). Then in the new Excel window select FILE, OPEN, then your 2nd spreadsheet.

Mar 29, 2011 | Microsoft Windows XP Professional

1 Answer

Excel is devloped for which operating system


Microsoft Excel has become a crucial tool in the international workplace, providing basic database functionality, along with spreadsheet and calculation tools. While it is currently the market leader for spreadsheets, the history of excel shows that throughout the 1980s and 90s it faced significant competition from rival software platforms like Lotus Notes, Mosaic TWIN and the Paperback VP Planner. The original Microsoft spreadsheet program was called Multiplan - which began development in 1982 - but it was never as financially successful as Lotus Notes.
Interestingly, Excel was first developed for the Macintosh operating system beginning in 1984. It made use of graphical menus and the mouse, innovating strongly relative to the other major competitors at the time. Drop-down menus and a point and click interface helped to make it more usable to non-technical workers, and in turn helped to influence graphical user interfaces in other software and operating systems at the time.
As such, when Windows was launched in 1987, Excel was one of the most important and popular pieces of software for it. The early exploration of the graphical user interface for Windows had already been conducted and market tested by earlier versions of Excel. While it was certainly not the first spreadsheet software package, it was the first to provide a powerful combination of usability and functionality to business clients of all sizes.
Lotus was relatively slow to bring Lotus 123 to Windows, failing to predict the popularity of the operating system.
One of the major turning points in Excel was the inclusion of Visual Basic for Applications in 1993, which greatly increased the functionality of the software. In turn, it also encouraged a generation of professionals to learn the programming language, further solidifying the long term demand for Excel over other spreadsheet suites


Read more: http://www.brighthub.com/office/collaboration/articles/13188.aspx#ixzz1IWkjtDx5

Oct 30, 2010 | Answer Racing Ion Motorcycle Jersey 2010

2 Answers

Have a excel password protected file. have forget my password. help me in opening my file


How to Crack Excel Spreadsheet Passwords by Petri IT Knowledgebase Team - January 8, 2009 Often when an employee departs, they take important Excel passwords with them. This guide outlines how to use a simple Excel password recovery application to crack lost or forgotten passwords, allowing you to unlock password-encrypted Microsoft Excel documents quickly as possible.
Step 1: Download and Install the Office Password Recovery Utility To perform the following recovery steps, you'll need to grab the download of Office Password Recovery Pro, available directly here. (2.1Mb)
Once you've downloaded the program, run the install with the default options.
Step 2: Navigate to the Protected File and Begin the Recovery Process Click the Open button on the top left, navigate to the protected spreadsheet file:

May 09, 2009 | Computers & Internet

1 Answer

Loaded Software - Excel crashes after displaying print setup box.


The reson is because you have not installed the latest printer drivers. try updating printer drivers or contact you printer manufacturer for further assitance

Feb 06, 2009 | HP Officejet J5780 All-In-One InkJet...

2 Answers

Import data from access into excel where one column go into one worksheet and other into next


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Average handle time


I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

1 Answer

Consolidate few sheets under 1 excel


What version of Excel are you working with. Newer versions allow you to have multiple spreadsheets grouped together into what is called a, "Workbook." To view the sheets separately, you simply click on the tabs at the bottom of the workbook. The easiest way I know of to join spreadsheets together into a single workbook is to open all of them at the same time, then choose, "View / Arrange All," and they'll be small, but you can grab each one by its tab and drag it to the workbook you want them in. Then you save the workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to them (or else you'll lose your 'back-up' data). Voila! You open one file, and all your spreadsheets are available with the click of a mouse.

Dec 18, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

96 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...