Math Student Help

I have dozens of charts in one worksheet and I want to change the x and y axis so that they are all standard.. Is it possible to change them all at once or so you have to do one at a time?

You’re pretty much stuck doing them one at a time. If you know how to program in VBA, it is possible to do them all at once. It’s all a matter of how many you have to do. If it’s <10, you’ll use up less time reformatting each one individually. If you have a lot more than 10, it might be worth it to search the web for VBA code examples others have written to reformat charts en masse.

Go to http://rulesmadesimple.com

My Foreclosure Sale Worksheet is a must when purchasing Foreclosed property.

Go to http://rulesmadesimple.com fill in the form and you’ll receive it instantly.

Disclaimer: This video and the corresponding e-mails are NOT meant to be, and shall not at any time be construed as,
“Legal Advice”. If you need legal advice, or If you need help in finding an attorney, you may call the Oregon State Bar’s
Lawyer Referral Service at (503) 684-3763 or toll-free in Oregon at (800) 452-7636.

Duration : 0:8:16

(more…)

Story

Duration : 0:5:20

(more…)

Hi, so I created a worksheet in excel with common macros that I would like to have available to me every time I use excel. The problem is, now every time I open up an excel file, the worksheet containing the macro will open up as well, and I’ll have to hide it manually. How do I keep this macro worksheet from being visible each time I open excel?

Are you sure that you don’t mean workbook and not worksheet?

Both of the first two answerers gave you some good data, it’s just that neither one really pieced things all together.

1.) Only the really old Excel macros that didn’t even run on VBA are actually contained on sheets. If they are the really old macros, there’s not really much you can do.

2.) If you are wanting to hide just a worksheet, there are really two or three ways you can do it. Here are the easiest two ways:
a. Select your worksheet then go to Format > Sheet > Hide
b. Press Alt + F11 to open the Visual Basic Explorer window, then in the Project Window in the top left corner click on the worksheet in the workbook you want to hide. Then go down to the Properties window to the Visible property. Set that to xlSheetHidden or xlSheetVeryHidden. The difference between the two is that the one hides the worksheet but if you go to Format > Sheet > Unhide you will see any sheets that have xlSheetHidden. Ones that are set to xlSheetVeryHidden aren’t listed and can’t be unhidden by the user without going through Visual Basic somehow. If you can’t view the Project or Properties Windows go to View > Project Explorer for the Project window or View > Properties Window for the Properties Window.

3.) Before you consider using an Add-In, you might consider using the PERSONAL.XLS file. The PERSONAL.XLS file works just like an Add-In. The PERSONAL.XLS file opens as a hidden file everytime you open Excel as long as the file has been created. If it has been created, you should see a project called PERSONAL.XLS in the Project window. To create the PERSONAL.XLS file, just record a macro and change "Store Macro In" from "This Workbook" to "Personal Macro Workbook" when you record it. Then just put your macros in the PERSONAL.XLS file.

4.) Another way of doing pretty much the same thing as the PERSONAL.XLS file is to do an Add-In. Follow the one answer’s instructions on that. No need for me to put the instructions here and make my answer longer than it already is.

I have an important Excel spreadsheet that needs to be edited constantly by multiple people. Is there any way to do this without having to resort to constant questions of "Can you close the worksheet so I can get out of read-only?"

Thanks for any help you can offer!

Definitely possible. In Excel 2007 go to
Review>Share Workbook> Select "Allow changes by more than one user at a time.This also allows workbook merging"

There is also some advanced options available there. Try that.

In Excel 2003, Go to
Tools>Share Workbook

Now you can open the same workbooke simultaneously by more than one user.

The story of three high schoolers on an epic journey to find the answers to a demonic worksheet so they don’t flunk out.

Duration : 0:8:31

(more…)

There is a way to make the name of the sheet appear in the header. What I would like to see is the name of the sheet automatically appear somewhere within the worksheet itself. I plan to use this as a template such that there will be worksheets with different names in the future. How can one make the sheet name appear automatically in a particular cell in an excel worksheet?

copy&paste this formula

=MID(CELL("filename"), FIND("]",CELL("filename"))+1,255)

you can do much more (filename, filepath)…see source.

I have my stocks listed in the excel program but I don’t like updating them by hand. I would rather enter a formula so that the worksheet gets updated automatically. Is there anyway to do that?

You need some kind of "marco" designed to access the web using Excel. Google for it. I’m sure someone has thought of that.

Benito Mussolini

Duration : 0:0:12

(more…)

I have my stocks listed in the excel program but I don’t like updating them by hand. I would rather enter a formula so that the worksheet gets updated automatically. Is there anyway to do that?

This can be done by linking to an external data source. The link below offers step by step advice on how to link it to Yahoo’s Finance site.

http://www.ehow.com/how_2027266_stock-prices-excel.html

It doesn’t mention that you can have it auto update every 1 minute by right click the data selecting data range properties and editing the refresh control.

Using that method the quickest it can refresh is every 1 minute. If you need it quicker than that you can record a macro and the following line of code to the end:

Application.OnTime Now + TimeValue("00:00:01"), "Refresh"

Where Refresh is the name of your Macro

This will refresh every 1 second (change 00:00:00 part for any time in hours minutes and seconds.