worksheet sliding when cell is tabbed
Good morning, i have a problem where i select a cell and by using right or
left arrow the work sheet move rather than the cell, normally when you tab a
cell the worksheet would remain in place until you reach the last viewable
column, them the entire sheet would move, this time if i select cell A1 and
right arrow Column A dissapear to the left.
Can anyone help to fix this?
SCROLL LOCK is ON. Turn that OFF.
Jacob (MVP - Excel)
> Good morning, i have a problem where i select a cell and by using right or
> left arrow the work sheet mo...Create a template for every worksheet
I need to create a template that can be updated later for 80-some worksheets
in a workbook. Basically, each tab has some information in common (which is
updated every year) but some information which is unique. In the past, I
just created the first worksheet without any unique information, and
copied/pasted to new worksheets. The problem is, if I need to update
something on all of them, I have to go back to everyone individually and
copy/paste. Is there a way to make a template that will automatically update
all worksheets based on it? Thanks!
...Replace cell of column with cells of other worksheet
I have the following problem.
In one sheet I have a table with imported keys from an
Now I want to replace these keys with strings that are in
a second worksheet. So eg when a cell in the 1st sheet
has value 2 it has to be replaced by eg "the second"...
How can I do this for all the cells of that column
Thanks a lot.
I'd suggest VLOOKUP, if it weren't for
> all the cells of that column
Find & Replace is probably out, since what works for "2" will affect 12, 20,
21, 22 ...
Depending ...Multiple worksheets with non consecutive dates
I have 10 worksheets per workbook. Each worksheet has the same parameters of which I would like to trend. However due to the dates in each worksheet differing (and non consecutive), the chart accepts the dates of the first worksheet as the x-axis and plots all subsequent worksheets in sequential order
Worksheet 1 Worksheet
Jan 1 44 Jan 29 2
Jan 4 55 Feb 35 8
The chart would use Jan1 and Jan 4 on the x axis and plot worksheet 2 values in the first (Jan 1) and the second (Jan 4) values on the x axis
Watergirl...Extracting data from a worksheet based on a range of in a column.
This is my first post to the group!!
Here is what I have to get it started:
Worksheet(Manuf#) 26025 records (Product#, Description,Buyline, Manuf#)
Worksheet(Products) various amount of product ID's in column A(only
column of data), this all I want to have in this worksheet, just the
list of products I want to find from Manuf#.
So what I need is a macro, Module, whatever it will take so I can look
at the Products in Worksheet(Products) and extract just those Records
from Worksheet(Manuf#) into a new Worksheet named Results?
Any help at this time would be greatly appreciated.
...Insert image in a protected Excel worksheet
We are using Excel 2000 and are facing a problem. The worksheet is password
protected. There is an unprotected cell for user signature.
The user is able to type in their name. But not able to paste a Jpeg or any
image file. How can I fix this?
...How do I stop 'template help' from opening in a worksheet?
When I open a workbook, I do not want to see 'Template Help.'
2003 version Help>Online Content.
Uncheck "show template help when available"
2007 version.....no idea but willing to learn.
Gord Dibben MS Excel MVP
On Sat, 29 May 2010 08:08:01 -0700, Goldenbarstewart
>When I open a workbook, I do not want to see 'Template Help.'
...How to hide worksheet columns & prevent unhiding for certain users...
I have a worksheet with hourly rate column and hours
columns. Because of the confidentiality of the hourly rate
so I would like to hide the rate column but still able to
allow my team to enter hours. Sounds like I really want to
prevent unauthorized persons to un-hike the rate column but
still allow them to update hours columns.
Is it somethig do-able in excel?
Thanks in advance!
p.s. unfortunately I cannot redesign the workbook to
separate sensitive information in the separate workshet.
- select the cells for which you want allow entries
- goto 'Format - cells - Protect...Dynamic Excel Worksheet on our Portal for Non-CRM Users to View
I wish to share certain information out of CRM with users who are not CRM
users. I know I can create a spreadsheet and post the spreadsheet, but then
we have to manually update the spreadsheet on a regular basis for this to
have any value.
The concept I came up with was to create a dynamic worksheet in Excel,
format the view the way I want it, and upload it to the portal. That works
great for anyone who is a CRM user, but doesn't work at all for those who are
not CRM users.
I'm not sure if I have a CRM issue or an Excel issue. How can I create a
worksheet that displays the ...Compare 2 worksheets #2
How do I do a side by side comparison of two worksheets?
If you are using Excel 2003 use "Window>Compare side by side with..."
For other versions of Excel check the following knowledge base article
> How do I do a side by side comparison of two worksheets?
...Shuts Down When Copying Worksheets
When I right-click on a worksheet tab, choose create a copy and tha
past it into a new WORKBOOK Excel completely shuts down
Message posted from http://www.ExcelForum.com
I had that happen once to one of my workbooks.
It was just one worksheet in a workbook with many worksheets.
My first workaround was to save the original workbook (with the problem sheet).
Right click, move or copy, but choose MOVE.
excel didn't crash.
Close the original workbook without saving.
This worked ok for me, but scared the heck out of me. I was using xl97 at work
where the problem occurred, and xl2002 a...My worksheets will not maximize.
hitting the maximize button just toggles between two difference sizes,
neither of which is maximized. There is only one worksheet open, no
duplicates, no hidden worksheets, etc.
...copy worksheet containing form
I have several worksheets which I use to print delivery forms that have been
provided by vendors for national accounts. Each time the vendor changes a
different workbook must be opened.
What I would like to do is consolidate all these forms into one workbook.
How can I copy the entire worksheet including all spacing, merged cells, etc
into a different workbook?
Start a new workbook.
Open up one of the existing workbooks.
Select the sheets you want to copy into your new workbook.
(Click on the first and ctrl-click on subsequent)
Then Edit|Move or Copy Sheet
Select your new book in the &qu...how do I input zip codes with a leading zero
I live in the NE where zip codes start with a zero. I have gone in and tried
all options under format cells. I even entered some coding that would let me
input what I need and it did not work. I am trying to set up a mail merge in
Microsoft Word (I have Microsoft Office 2003 Standard Edition) and all my
zips show up without the leading zero. Please help!
Tried that, thanks... still does not work!
> format --text
If you format the cell as text, then type in your zip code (with the leading
zero...max rows on an Excel worksheet
I thought the maximum number of rows available on an Excel
spreadsheet was 65,536. But recently I was told the
number of rows could be increased by decreasing the number
of columns. Is that true? If so, how is it done. Sorry
if this question has been asked before, I tried searching
the site for others who might have asked this question,
but the search feature is off.
Sorry, your informant is incorrect.
65,536 is all you get.
One option if you need more is to spread your data over a number of sheets
and create a summary sheet to bring totals an other information back t...Hide Cells with Zero Value in Excel 2007 while using line chart ty
I am using Excel 2007 and have a situation with the charting functionality.
For example - I am trying to set up automatic update chart update for Jan 08
– Dec 08 data i.e. user just enters data each month and the graph trend shows
up each month. I have done this a lot of times but seem to have a unique
situation with excel 07 this time when I am using the line chart type to show
The date cells that have some kind of formulas used i.e. if function or
Iserror function etc. I tried to test the chart by entering data for January
it works fine with bar graph only displ...Linking Formulas, Worksheet to Worksheet
I need to set up a workbook with one worksheet per month for twelve months.
There will be formulas in each worksheets, two of which need to carry forward
totals from the previous month's worksheet. How do I link worksheets in this
Start at the latest sheet and click on the cell where you want the previous
sheet's data to appear, enter = and then go to the sheet that has the formula
you want to carry forward. Click on the cell with the formula you want
carried over and click enter. This should have the data you are looking for.
> I need t...Worksheet event help #2
Have the following in a sheet code that i would like to activate when
the enter key is pressed in B5.
tried the following, but no success, the 1st part i was hoping would be
the change event that would run a sorting macro in the 2nd part. any
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address(0, 0) = "b5" Then
Application.ScreenUpdating = False
ActiveWindow.FreezePanes = False
Selection.Sort Key1...Linking rows of data to another worksheet
Worksheet One contains survey data pertaining to customer satisfaction for
all of our building communities. The data is entered in each row as follows..
.. community name, lot number, buyer name, etc. Therefore, this worksheet
contains all the survey results for all of our buyers, and then based on the
survey responses, an overall rating is calculated. I would like to then link
each row to its corresponding worksheet per community. By doing this, I can
calculate the survey ratings per community as opposed to the overall rating
calculated on worksheet One.
I would greatly appreciate any as...Formatting Excel Worksheet
I have a spreadsheet which has various negative numbers entered as follows:
1,502.33- etc etc
Is there any way to format it or a formula which will change the above
numbers so that it is a negtive number
1,502.33 etc etc
I have tried all the usual ways to format it but the numbers still remain as
5.25- etc etc
this should do it
For Each c In Selection
If Right(c, 1) = "-" Then c.Value = "-" & Left(c, Len(c) - 1)
"KI" <KI@dis...Vary column width and row height in the same worksheet
In Word, I can create two tables with different column width, then remove
line to combine the two tables together.
Can I achieve the same different column width and row height in the same
worksheet? Either one on top of the other, or side by side?!!
In XL, height and width are properties of entire rows and columns, so
you can't achieve what you're looking for exactly.
There are workarounds. Among them:
- you can merge cells so that they appear to be wider/taller than their
surrounding rows/columns. I don't recommend this as merged cells
typically interfere with formattin...Display Binary Leading Zeros
Forgive me if I'm just obtuse, but I can't seem to get Excel to display the
leading zeros of binary numbers. (I'm just doing up an ASC/DEC/HEX/BIN cheat
Formatting the cells as "Custom :: 00000000" doesn't work.
Any ideas as to how I do it?
Thanks in advance!
If this is just a cheat sheet - with no computation involved, try putting a '
in front of the zeros ('0000). The ' won't show in the cell or when you
print it out.
> Forgive me if I'm just obtuse, but...Query: Link data between worksheets?
I'm trying to find a shortcut to save me some time.
This is the problem:
I'm setting up a master worksheet, and 30 to 40 "slave" worksheets tha
need to run off it (all within the same workbook). The slave worksheet
all retrieve data from the master. The data is setup to run across i
rows (i.e. Row 1 contains 1 record). Each record has an individua
identification number entered in column A.
Is there a way that I can tell the slave sheets to copy an entire row
based purely on the identification number entered in column A?
Thanks in advance if anyone can help, as this could ...Worksheet Autostarts
Recently installed Excel 2007. When I start Excel, a certain worksheet always
autostarts. I do not recall any settings allowing that to happen.
All versions of excel will look at the XLStart folder and open the files within
Each version of excel has an option to open files in a specified folder, too.
In xl2003 menus, it's specified in:
tools|Options|general tab|"at startup, open all files in:"
It's in the Office button|excel options (somewhere) in xl2007.
> Recently installed Exc...Moving worksheets between diferent workbooks
I need to move a worksheet from an old workbook to
The worksheet that I want to move has macros and I want
to move it with everything-macros, buttons of macros,
What is the easiest way to do that?
Thanks in advance
copy the sheet
Edit=> move or copy sheet
I would make a copy until I knew it did what I want. (click the make a
Tim <email@example.com> wrote in message
> I need to move a worksheet from an old workbook to