Freezing panes
Tue, 11 May 2010 14:04:43 +0200
I wish to freeze the upper left corner of the first 5 cells (A1:A5) so that
if I scroll right or down the freezed cells will just stay visible whereever
I am in the sheet. But I cannot manage to do so. When I freeze the cells and
if I scroll down, then the RHS of the freezed cells stay also freezed which
I d ...
|
Opening XML - saving as Excel
Tue, 11 May 2010 09:33:14 +0100
Can someone please tell me why, if I open an XML file in Excel 2007 and
then try to save it as an Excel file, without doing anything else,
rather than using the first part of the XML filename & changing the
extension, Excel insists on trying to save it as Book2.xls?
Is there a way to stop this and make it d ...
|
Re: Using pivot tables
Tue, 11 May 2010 07:53:08 +0100
On Mon, 10 May 2010 at 13:34:01, Nadine
<Nadine@discussions.microsoft.com> wrote in microsoft.public.excel :
>Clicking on the link didn't do anything for me but place your cursor inside
>the pivot table and right click. Choose Pivot Table Wizard and choose
>Layout. Rearrannge your cells here. Hope that hel ...
|
Group Editing
Mon, 10 May 2010 15:33:25 -0600
Excel 2007
I would like to freeze the top row in all of the worksheets in a workbook.
I remember from earlier versions of Excel that it is possible group all the
sheets together, then edit one sheet and have that change show up on all
sheets. That works if I actually change the contents of a cell, but it d ...
|
Re: Using pivot tables
Mon, 10 May 2010 17:24:45 +0100
I've been told that, using pivot tables, I might be able to re-arrange
the following data (the Guardian's full general election results)...
http://spreadsheets.google.com/ccc?key=tdLut_gO0qo_C0JevIxnZ2g
... so that the party results by constituency could be more conveniently
arranged in columns, rather tha ...
|
Unhide command?
Mon, 10 May 2010 12:12:58 -0400
I tried to edit a macro in Personal.xls by highlighting it under Macros and then clicking
Edit. I received the error comment
"Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command."
Where is the unhide command?
rs
...
|
Print to specific printer -- macro
Mon, 10 May 2010 12:05:47 -0400
I tried to record a macro to print to a specific printer, but this is all I got:
Sub PrintToBullzipPDF()
'
' PrintToBullzipPDF Macro
' Macro recorded 5/10/2010 by Robert Shiffman
'
'
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
How can I name the pr ...
|
|
|
Last entry in a column
Mon, 10 May 2010 11:29:13 -0400
Is there any way to write a formula to send the last numerical entry in
a column (range?) to a designated cell, _without using VBA or other
programming_?
1
2
3
4
Therefore, send the contents of the last cell (4) to designated cell (C1)
Next day (after an entry) the column might be:
1
2
3
4
5 ...
|
.xla placed in XLStart folder shows up as 'default' book.
Mon, 10 May 2010 07:51:14 -0400
Microsoft says: "Add-ins (.xla files) that you put in a startup folder do
not typically appear when you start Excel. The add-ins are loaded in memory.
The add-ins run any auto macros."
Well, my .xla add-in does appear as the 'initial' default spreadsheet
(instead of 'Book1', which used to, and what I am sur ...
|
Column Of Numbers To A Text Format Problem
Mon, 10 May 2010 07:15:09 -0400
Hello,
Using Excel 2007 and W7.
I have a column of numbers, many of which are
0
00
000
etc.
I wish to utilize them as text in many cases, and want all the zeros to
stay.
If I define a new Column, beforehand, as text, and enter them
individually into this new column, no problem.
They are left jus ...
|
