| Thread | Last Post | Replies |
|
| Date & Time Excel | 01 May 2008 00:01 GMT | 1 |
=Now() working Butt Time Is Not Working Like As Clock Mean As after 60 Second Must Be change the word of min Like if Now 23:52 after 60 second it will become 23:53
|
| restore worksheets tags | 30 Apr 2008 17:05 GMT | 1 |
I'm working with a biz plan builder that allows tables be exported to Excel. It works nice, but workbook does not show worksheets tags (eg Plan1 Plan2 etc) and there are 24 of them. They're all there, since the command Hide Worksheet works well. But I really do need the tags to ...
|
| How do I turn excel columns from column number to column letter? | 29 Apr 2008 10:15 GMT | 1 |
|
| Customizing Menus and Quick Access Toolbar in 2007 | 28 Apr 2008 14:58 GMT | 5 |
In Excel 2003 I was able to add a menu and then add macros to it. I was also able to add macros to custom buttons to any toolbar. In 2007 I can create a custom button within a workbook to which I can add a macro, but how do I add it to the ribbon bar? How do I add a button with a ...
|
| EXCEL FILES RECEIVED, CAN'T OPEN | 28 Apr 2008 13:53 GMT | 2 |
I TRIED MANY TIMES GOING TO DEFAULT PROGRAM -BROWSE - MICROSOFT OFFICE-OFFICE 12 EXCEL -FILE NAME- OPEN AND NOTHING HAPPEN WITH NO SUCCES. I RECEIVE EXCEL FLES OVER INTERNET AND I CAN'T OPEN. I HAVE EXCEL OFFICE 2007 AND EXCEL OFFICE 2003.
|
| Formatting not staying on | 28 Apr 2008 10:51 GMT | 7 |
I have some cells with Autofit ON on the first sheet of my workbook. I want the same formatting on the other 4 sheets, but even although I have individually applied Autofit to the cells I want, it does not see this formatting. The idea is for all the sheets to mimick the first ...
|
| Setting up Excel to search by columns instead of by rows, by defau | 27 Apr 2008 19:50 GMT | 2 |
Each time I open Excel, I have to configure the Ctrl+F search dialog box to search by columns instead of by rows. Is there a way to do this permanently, so that I do not have to set this up each time I load Excel? (By the way, I would also like to search by Values instead of by ...
|
| Excel 2007 Column Maximum | 27 Apr 2008 01:48 GMT | 2 |
How do I change Excel 2007 so I can use more than the 256 columns that are currently displayed as default. I realise that in the 2007 version the maximum columns is controlled by memory of which I have heaps. Thanks
|
| stop number to date conversion | 26 Apr 2008 20:50 GMT | 2 |
is there a switch (i haven't been able to find one) for turning off automatic number to date conversions? currently i have to keep all cells formatted to text, to avoid this, and not have 1-2 turn into jan 2. or having to remember to type apostrophe before. i'd rather leave ...
|
| changing default format with personal.xls | 24 Apr 2008 18:46 GMT | 5 |
excel 2007 i am trying to get new worksheets to start with using text in all cells and wordwrap. i unhide personal.xls, make the changes, save it. close and reopen excel.
|
| Excel- smooth scrolling (instead of 'snap' scrolling) | 24 Apr 2008 14:16 GMT | 2 |
I'm fighting with the default scrolling in excel. When scrolling in excel it 'snaps' to each cell. Is there any way to turn this off? This ‘feature’ is especially annoying when scrolling horizontally through large cells. Thanks.
|
| Excel 2007: Data filter Arrow | 24 Apr 2008 08:50 GMT | 1 |
Hi - having read numerous complaints with the inability to easily change the 'blue arrow' when filtering data with the auto-filter in pre-2007 Excel. I Personally never had a problem. Having just bought 2007 - now there is not even a blue arrow. Can we get
|
| Dynamic Ranges in 2007 | 22 Apr 2008 21:25 GMT | 1 |
In 2003 I set up dynamic ranges and used them as the data source in a chart so the chart would automatically expand to included added data. In 2007 I set up a named OpenRange on the 'Calculated data' sheet: =OFFSET('Calculated data'!$C3,0,0,COUNTIF('Calculated data'!N:N,1))
|
| Auto fuel cost | 22 Apr 2008 18:17 GMT | 1 |
I am looking for an auto fuel cost calculator that keeps track of date,place, number of liters, price per liter, total cost and number of liters per hundred kilometers, and a running total.
|
| SBERET.MSI File Missing - Excel/Office XP 2002 | 21 Apr 2008 03:07 GMT | 7 |
Greetings to all... Up till today, all of my XP Office (2002) apps have been running fine. Suddenly and inexplicably...and only as of today, when I try to open Excel or any of my many Excel documents, Windows Installer initiates and starts
|