Question about Microsoft Office Standard for PC

1 Answer

Microsoft excel How to insert 100 sheets at a time in an excel work book?

Posted by on

1 Answer

This solution on average add 10 new worksheets in less than 5 sec.
Hold down shift key, then hit F11 as many time as many sheet you want to add
Other than SHIFT+F11, ALT+SHIFT+F1 also Insert a new worksheet, it's just to you which is more convenient.



Regards,

Posted on Sep 19, 2008

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

Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.


Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

  1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
  2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
  3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
  4. Then, press Alt+Q to close the Visual Basic Editor window.
  5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
  6. Then, save the Excel Sheet.
eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

1 Answer

Excel 2003 cell is highlighted, font color is selected, but the color on the screen remains black. When printing the color prints out correctly while showing black on the screen


to remove all formats....
i.e.
open another workbook....
copy all data from the present sheet to the new work book....
present workbook
select data/edit/copy

new work book
select cell edit/paste special/values

now do the formating/color/font/size etc in the new workbook and check if they work here

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Excel sheet opening problem


Do you have a CD OR Installation files of office? If yes then run the setup and repair your office installation.

Apr 01, 2009 | Computers & Internet

1 Answer

Excell link sheet


click insert from the tool bar & clik hyperlink. click on the xls file you want to add

Jan 05, 2009 | Microsoft Excel for PC

2 Answers

Copy-paste


it should be

=7/4  or =100/30
and excel will give you a numeric result.

Oct 18, 2008 | Microsoft Excel for PC

1 Answer

Microsoft Works Please help


Get new stuff you don't have to look through particularly grotty Half-Price Books (though you could use AbeBooks) to obtain relevant manuals! Linux and OpenOffice can do your job; OpenSolaris and one of Sun's office suites can too. Your machine won't be zombified every time you hit the internet with it this way, too.

Works and Excel differed in several editions. You might not be able to just rightclick on the tab and ask select New Worksheet or Edit/Insert/Worksheet.

Mar 20, 2008 | Microsoft Windows 95 NT 4.0 Workstation

1 Answer

CONNECTING VB TO EXCEL


Here is some code that I found in this book:
Microsoft Visual Basic 6.0 Professional, Step by Step.
By Michael Halvorson
Second Edition.
ISBN: 0-7356-1883-6
Code removed for possible copyright issues.

That program in VB6 will open an Excel workbook, and then insert the data into the cells at B1, B2 and B3.
You can change this to have a textbox show up to ask for info to insert into the cells as appropiate.

If you look at www.microsoft.com/mspress/developer and search there, they may still have some code that you can download.

Feb 21, 2008 | Microsoft Windows XP Professional With...

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

1 Answer

Excel Loading Problem


try using OpenOffice.org instead of Microsoft Office. It should work and it's free.

Dec 07, 2007 | Microsoft Excel 2000 Step by Step...

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

169 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

18375 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...