General

Is there a simple way to generate patterns of numbers in XL ?
Hi I often want to generate simple patterns of numbers, but have yet to find an easy way of doing this in excel. It's really easy in minitab (for example) to get simple patterns using the 'set' command ... MTB > Set c1 DATA> 1( 1 : 72 / 1 )32 DATA> End. This generates (in column 1) 32 1's, then 32 ... 6 Apr 2010 23:11

How can I go from one tab to another without using the mouse?
How can I go from one tab to another without using the mouse? ... 30 Mar 2010 20:45

Printing a worksheet in two (or more) columns
Hi, I've got an extremely long spreadsheet table comprising two columns of data. I'd like to print these data in a more compact form - in the same way that the entries are organised in a telephone directory. Say on average my page is 50 rows high - my first two columns on page 1 would appear on the left ha... 30 Mar 2010 19:35

vba code to get an duse the value from a particular cell
Using xl2003, I have the following Worksheet Selection Change code: If Target.Column = 5 Then Target.Columns.ColumnWidth = 27.11 ActiveWindow.Zoom = 85 Else Columns(5).ColumnWidth = 3.78 'ActiveWindow.Zoom = 75 End If I would like to be able to change the values zoom 85 and... 30 Mar 2010 22:59

How can I remove a link that won't go away
When I click on the "Break Link" button, the link doesn't leave. ... 30 Mar 2010 19:35

using THREED function with VLOOKUP to sum across multiple workshee
Hi, I am having the same issues as others but haven't been able to resolve them. The formula I have tried after the add in installation is =SUMPRODUCT(--(THREED('General Scientific:tab1'!A3)=AE3,(THREED('General Scientific:tab1'!J3)))). I am looking to sum j3 numbers in the same cell in every tab if the crit... 31 Mar 2010 09:52

Hyperlinking images
I have a worksheet with several columns. One of the columns is entitled image which I've hyperlinked to image files. I thought that if I were to email this worksheet to someone else that my images would go along with it. Not happening. How do I set it up, so that the images are embedded on each row as a ... 31 Mar 2010 12:08

Cannot open spreadsheet
I cannot open a spreadsheet from an e-mail attachment, from a hyperlink or from Windows Explorer. Excel opens and the blue screen indicates "ready" but the file won't open. The "Ignore other applications" option is not checked. Sometimes I can get the file to appear on the screen if I click off Excel to anot... 30 Mar 2010 17:17

personal.xls created in Excel 2007 and opened in Excel 2002
I have added new macros to Personal.XLS, using Excel 2007. The macros were created in Excel 2002, and modified in 2007, but saved as an xls file. If I transfer the file to the machine using 2002, I get a message stating that the file is corrupt. it opens it, and looks like gibberish on the page. Is this fil... 30 Mar 2010 16:09

Windows 7 Excel 7
Over the last week while in a spreadsheet, excel has just arbitrarily begun to restore/repair a file. This has happened a couple times, no power failures or surges... A converter had been installed, the system went back to a restore but it has happened again. I then have to save as another file name. ... 30 Mar 2010 16:09