Macro to blank row on bew sheet
Wed, 17 Sep 2008 09:33:26 GMT
Can you help please
I am writing a data base in excel for our school, to track the resources, I
need to have a macro that will take person from the Index Spread Sheet to a
Spreadsheet called "Loan Area" and then take them to the next available
(empty) row on that sheet so that they can fill in their details,
I ...
|
How do I set default Excel Saveas file format to xlsx not xlsx
Wed, 17 Sep 2008 02:11:02 -0700
The first time I select 'Save As' in Excel I always need to change the file
type from .xltm to .xlsx otherwise it saves as a template file. It is
annoying because if I forget I don't know about it until after I try to find
the file later. How do I change the default save-as file type to a standard
Excel fil ...
|
Want to open worksheet in preformatted style
Mon, 15 Sep 2008 09:06:11 -0700
I a CPA and almost all my worksheets need to be formatted in a number style
with 2 decimal places and comma separator. How do I format my worksheet so
that ever one I open up is already formateed to numbers, 2 decimal places and
comma separator?
...
|
Re: Product Key
Sun, 14 Sep 2008 19:06:02 -0700
anybody care to let me use their product key so I can use my Microsoft Office
2007. I bought a new computer and installed my MO 2007 but I can't use it
because I don't have the key.
Thanks
DJ ...
|
Pivot Table Default
Sun, 14 Sep 2008 17:29:01 -0700
Is there any way to change the Default Pivot Table Options?
The Classic Pivot table is much easier to interpret.
...
|
Re: Product Key
Sun, 14 Sep 2008 02:44:00 -0700
I bought a new computer and installed Office 2007 that I purchased last year.
I threw away the plastic box with the Product Key on it and I need a new one.
How do I get a new product key? ...
|
How do I add a customized button with macro in Excel 2007 for acce
Sat, 13 Sep 2008 13:39:02 -0700
I have macro to run PasteSpecial with pasting values only. In Excel 2003,
it's launched by clicking a toolbar button. Now upgrade to Excel 2007 though
I can customized quick access bar, but how do I associate the macro with a
button or something and add that button to quick access bar or some
customized ri ...
|
|
|
Automate Cut & Paste
Fri, 12 Sep 2008 07:25:01 -0700
I have a query that pulls information from various access tables and then a
report is generated in excel by rep name. Is it possible for each rep to
have their own excel file? As of now I cut and paste each reps information
to a separate excel file and then email that information as an attachment to
them.. ...
|
How do I import my fill color table from Excel 2003 into Excel 200
Thu, 11 Sep 2008 14:23:02 -0700
I have thousands of Excel 2003 spreadsheets with my customized cell fill
color table. I need to have consistent cell fill colors in Excel 2007. I
found where I can customize one "row" of fill colors manually in Excel 2007 -
what a pain?
any help is appreciated!
It is VERY OBVIOUS that MS did not have i ...
|
excel 2007 click selects multiple cells
Thu, 11 Sep 2008 05:50:01 -0700
In the last couple of months, when I click on a single cell in my .xls
spreadsheets, two or more cells get selected. Very annoying! Other people
have reported it in other forums, but no solutions.
When I right-click and hold, I see "1R x 2C" or similar in the top left
corner, as if I'm shift-selecting.
The ...
|
