How to protect data in rows from being seperated during sort
I have a huge spreadsheet that needs to be sorted a million times but several
people. The problem is that during some of the sorts they don't always grab
the whole row and the data then gets scrambled. how can I protect the sheet
so that the rows can be moved and sorted and edited but the data within the
rows always stays together
If your sheet is not too dynamic, and tends to stay the same size, then
simply create a named range.
Select *all* the rows and columns concerned.
Click in the "Name box", and enter a short appropriate name, like "sort" (no
quotes), an...universal formatting of all cells in all worksheets
I have 140 sheets in an excel document. In column AF I
want the width to be set to 15.86.
Instead of going to every sheet and making the change, is
there a way that I can set the width for that column in
all of the sheets
right click on a sheet tab>select all sheets>set whatever on the sheet you
are on>select any One sheet.
Granite Shoals, TX
"jeremyrod" <firstname.lastname@example.org> wrote in message
> I have 140 sheets in an excel document. In column AF I
>...protect file from getting deleted
I have made a file in Excel 97. I want to protect it in
such a way that nobody should be able to delete it.
Nobody should also be able to save another file on it.
Can anyone help please
There is no way that you can with 100% certaintly prevent
a file from being deleted or overwritten. This is why the
first three rules of computing are backup, backup and
backup. When you are done working on a file, copy it from
your hard drive to what ever else you may have access to.
IE,a second hard drive, server drive, floppy, CDR, zip
disk, USB Key drive. If you don't have access to a...Excluding worksheets from printing
I currently embed an Excel macro in my spreadsheets which will print
the entire workbook (40+ sheets) should the user request it:
Private Sub CommandButton2_Click()
Dim Sheet As Worksheet
Dim lAnswer As Long
lAnswer = MsgBox("This report contains " & Sheets.Count & " sheets - Do
you want to print them all?", vbYesNo, "Print?")
If lAnswer = vbNo Then
However, I have now incorporated several workings sheets that a...cut and paste to different worksheet
> I am working on excel sheet to make a daily production report. In my
> worksheet, there are 300 rows selected for a week and column from A to W. Column F is named as "STATUS".
When a particular job finishes, person on the section puts C (C means
Completed) in the column F. What I am after is as soon as column F (Status)
goes C, then information for that job from column A to column W should get
copied automatically to another worksheet 3.
consider in one day 10 jobs gets completed onto a section then 10 jobs
infomation from column A to column W s...Single worksheet, multiple pages?
I have a single excel worksheet, and due to area's of the sheet I do not
want to have printed, (the data is to be printed onto pre printed forms),
have used the set print area option to exclude those area's.
The problem is now I have multiple pages inside a single worksheet. Each
page prints seperatly, so I end up with 5 pages with only a small amount of
the full worksheet on each.
Thanks in advance
i'm not sure what you're problem is - sounds like you've set it up and got
it working like you want - how would you like it to be different?
chee...Graphics: get data from different worksheets
I just wanted to ask if it is possible to make a graphic in a
worksheet and get the data from other worksheets...I don't know if I
explained myself clearly!
Thanks in advance!
...Question About Importing Columns From A Datasheet to A Worksheet
I am asking for any help you can give me regarding the best way to import
columns from a datasheet into another worksheet. I have many worksheets to
construct but I will need to include only a few select columns from the
datasheet on each worksheet. Each worksheet will include a different
assortment of columns. It is my goal to only continuously update the
datasheet information, so all the changes will carry over to all the
worksheets without me having to manually update every sheet. I know how to
do this function per cell, but I cant figure out how to do it by column.
Please...Protecting Selected Cells and Functions
I have a worksheet. In Cell B2 is a Data validation box Listing a range
of colleagues names( DRop Down Menu). On selection of a name in B2, the
contents of the whole worksheet changes.
I like to Protect the worksheet for:
1) Hiding the formulaes
2) And most importantly preventing editing of the contents of any other
cell (except B2).
and yet be permiitted to:
3) Select contents in Cell B2 (Data Validation Box)
4) Select Auto filters in Row 4
I've tried using the the Tools/ Protect worksheet menu, ticking Select
Lock Cells, Select Unlock cell, use auto filters. And in in
Format/Cells/...Column Auto Width and Hidden Rows
I have a macro that selects certain columns and auto sets the width.
The problem is it is using data in rows that are hidden.
How can I make it ignore these rows when selecting the width?
I'm not sure you can.
But you could copy that column (visible cells only) to a new sheet (in column
A), autofit that column, keep track of the width and use it on the original
Dim curWks As Worksheet
Dim tempWks As Worksheet
Dim rng As Range
Dim myWidth As Double
Set curWks = ActiveSheet '???
Set tempWks = Workshee...Enter same text in mulitple worksheets at the same time
I have a workbook that has 109 worksheets in it, now I need to have the same
layout on each page is there a way to type it on wrksht 1 so that it will
automactally enter the same text through out the rest of the wrkshts? Or is
the old fashion way the only way out of this?
Message posted via OfficeKB.com
Select the first sheet (click sheet tab), hold down shift and click the
last sheet tab to group the sheets, now enter the text, when done right
click any sheet tab and select ungroup sheets
Newbee via ...Is there an "Execute" worksheet function?
Is there a way I can get Excel to "execute" an expression that is
stored in a cell as a test string?
Say C4 contains "3+4". Can I put some expression in C5 that will
execute that expression and result in "7"?
I tried =calculate(C4) and a few other things, but no joy.
in the absence of putting = in front of c4, try this
Don Guillett Excel MVP
"LurfysMa" <email@example.com> wrote in message
news:o5fn83thi0g5tivf55abvhv...Auto Open #2
I have Excel 2003 on WinXP SP2.
I have copied a worksheet, "Invoice", into my Excel file called "Databased".
Although, I have broken all links in the worksheet but still it tries to
open the original file from where I copied the it. If the file is not found
I get following error when "Databased" is opened:
Cannot find 'C:\[ILYASBILLING Template (uw).xls]AutoOpen Stub Data'!, which
has been assigned to run each time [Databased.xls]Invoice is opened.
Continuing could cause errors. Cancel opening [Databased.xls]Invoice?
Now I have no ...Insert Existing Worksheets into a new Workbook
I have a set of many single page worksheets with calculations; I want to make
a single Workbook using all of those pages. Then I want to extract data from
a certain cell on each Worksheet and SUM that data on the last page of the
In EXCEL 2007 in order to extract and sum data on a specific page of the
1. Assume I have a Workbook set up in which there are 4 Worksheets and I
wish to sum cell C6 from 3 of those Worksheets in Sheet1.
2. In cell C6 of Sheet1 (this is where I want the total to appear):-
Home / Editing group / AutoSum /
3. Now click on ...How do I combine two worksheets into one graph
I have two worksheets on an Excel spreadsheet. I would like to take both
worksheets and place in one graph. Any suggestions?
Make a chart with data from one sheet. Then copy the data on the other sheet, select
the chart, and use Paste Special from the Edit menu to add the copied data as New
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I have two worksheets on an Excel spreadsheet. I would like to take both
> worksheets and place in one graph. Any suggestions?
...How do I sort worksheet without affecting formula values?
I have two worksheets, one of which has formulas which reference the other.
The problem is, I cannot sort the first worksheet and have the formula values
in the second worksheet follow it so the values stay the same. I have tried
making them absolute references ($A$1) but it doesn't help.
I feel your pain. I've ran into the same issue before.
The problem is the use of worksheet functions. The solution is DO NOT USE
worksheet functions. Use a VBA subroutine instead.
Here is an example:
With worksheet functions....
A B ...Save a single worksheet in Excel as a single file.
I have multipe worksheets in a single workbook. I would like to be able to
save each worksheet individually. I want to send each worksheet to an
individual, I do not want to send the entire workbook. All information must
be retained in the one workbook, but as the individual worksheets are
updated, the individual worksheet needs to be saved and sent to that
individual. Help anyone? Thanks.
you can probably find the answer here.
"Dakota" <Dakota@discussions.microsoft.com&...is it possible to Hide certain worksheets from certain users?
is it possible to Hide certain worksheets from certain users?
if Yes which version of Excel offers this option?
there is no built-in facility, you would have to build it all (and it is no
(remove nothere from the email address if mailing direct)
"Admin" <Admin@discussions.microsoft.com> wrote in message
> is it possible to Hide certain worksheets from certain users?
> if Yes which version of Excel offers this option?
It requires using macros, which may or may not work for y...Deleting groups of emails with auto-preview
I have a user that in Outlook Express he could hold down his shift key and
start scrolling down and each email would show a preview as he scrolled down
to determine which emails he wants to delete. I have upgraded him to
OutlookXP and when he holds down the shift key and starts scrolling, just
the first email is auto-previewed. Anyone know of a setting that would allow
him to preview each message as he highlights and scrolls to the bottom?
...Continuous page numbers in workbook of multiple worksheets
I would like the page numbers to start with 1 on the first worksheet in a
workbook and then have the next worksheet pick up with where the first
worksheet left off. For example, if the first worksheet has 2 pages and the
second worksheet in the workbook had 3 pages, then the first worksheet would
contain pages 1 and 2 while the 2nd worksheet would contain pages 3, 4, and
5. Is there a way to have Excel figure out what the first page number should
be in the 2nd worksheet or do I always have to manually update it in Page
Select all sheets first (right click on a...making textbox to be auto sizable
I added a Textbox to a Word 2007 document by going
to the Developer option(in the File menu), then chose Design Mode,
then Legacy Tools->Text box Field. The MultiLine
and Enterkey properties are set to True and the rest
are default. The textbox is of size so that it can take some
10 rows of lines. Is there a feature I can choose/set so that
when more than 10 rows of lines are entered the text box
will automatically expand? The rows need to increase so the
textbox needs to expand downwards to accommodate the
text more than 10 lines.
Can someone please advise if there is an inbuilt ...Auto Loans
I have an auto with an associated loan, and I am
purchasing a new car. I want to payoff the existing loan
and transfer the remaining principle to the new asset
(car)without it looking like the car cost more than I
paid. The transaction consisted of paying off car1 and
putting money down from a checking account along with the
remainder coming from the new car loan. Money does not
make this simple.
Maybe it's not simple, but it is certainly possible.
It may take several transactions. You might want to read the FAQ on mortgage
refinances and extrapolate.
"MikeF" <ano...command buttons disappear when I move worksheet 2007
Excel 2007 - When I move my worksheet containg command buttons that run VB
code to another workbook, the buttons disappear. How can I make the buttons
move with the worksheet?
I've never had this happen, but I use xl2003 much more than xl2007.
You may want to give details of how you did the move.
> Excel 2007 - When I move my worksheet containg command buttons that run VB
> code to another workbook, the buttons disappear. How can I make the buttons
> move with the worksheet?
...Auto generate a label/number
I would like to track orders and have it assign a new, consecutive order
number to each new record. Example we have order MCO25, the next new record
I would like to have it auto generate MCO26
> I would like to track orders and have it assign a new, consecutive order
> number to each new record. Example we have order MCO25, the next new record
> I would like to have it auto generate MCO26
The 1000th order would be MCO1000?
Public Funtion NextOrderNo() As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String
strSQL =...Why can't I enter any data on any new worksheets?
I cannot enter any information on any new, or existing worksheets. I've even
tried uninstalling and reinstalling the program. Please help!