Locking Panes Horizontally And Vertically?

Dec 7, 2012

I'm trying to lock the cells of my work book both vertically and horizonatlly. There are "header criteria" on both colums and rows that I want to lock so when you scroll down or over the title bars stay. When I've done it in the past it won't let me lock both correctly.

View 7 Replies


Freezing Panes Horizontally And Vertically

Aug 22, 2009

I know I can freeze panes eithe across a column or row but is it possibleto do both at the same time so that I can have a header row and a few columns on the left of the screen frozen?

View 2 Replies View Related

Autofill Horizontally And Vertically?

Mar 27, 2014

Basically I want to see more dates, as you can see I've dropped down Cell B1 (31-Mar) to the B28 (27-Apr) Obviously if I wanted to see past 27-Apr I would just continue the drop down but I want to keep it within 28 rows and carry the dates onto cell C1-C28, D1-D28 etc, is there any way to do this using the drop down function or will I have to drop down each column individually then look date in the last row of that column and type the next date myself on the next column and drop it down?

View 1 Replies View Related

Incrementing Formula Vertically And Horizontally

Jan 16, 2014

I have a spreadsheet with a summary tab and 30 data tabs. The data tabs are named page-1 to page-30. In the summary page I have the following formula in cell C39: 'page-1'!C20

I want to be able to drag horizontally across 30 cells and have it increment to 'page-2'!C20, 'page-3'!C20 etc.,
and also drag it vertically and have it increment to 'page-1'!C21, 'page-2'!C22 etc.

View 2 Replies View Related

How To Display Text Horizontally Instead Of Vertically

Feb 27, 2014

I have a list of numbers I want to display horizontally instead of vertically. Is there a simple way to do this other than retyping each number?

My worksheet is attached.

View 3 Replies View Related

Freeze Horizontally And Vertically At The Same Time

Mar 22, 2007

How do you freeze horizontally and vertically at the same time?

View 3 Replies View Related

Transpose And Consolidate Data Horizontally To Vertically?

Jun 4, 2014

In the attached spreadsheet, I have the original data display horizontally (sheet2). Col A is Patient #. The header in row 1 are the test codes. Each patient took only 1 test and have result reported either neg, pos, pending or not eval. How do I transpose the header and have the test results consolidated in 1 column accordingly as display in sheet 3.

View 4 Replies View Related

Table Automatically Extends Horizontally But Not Vertically?

Apr 17, 2014

For what reason would a table not extend vertically on it's own when an entry is made in the next row directly beneath it? On all of my sheets I could swear the table will automatically extend vertically, but on one workbook that has 10 duplicated and then modified sheets with tables (I mention that for it might have been something from the original that was copied that is the problem), the table easily expands horizontally when a value is placed in a column next in line, but not the same for the next row!

View 7 Replies View Related

Pivot Table Filtering - Display Sums By Date Horizontally And Not Vertically

May 14, 2013

I am working on a pivot table just like the one on the picture here [URL] .......

Ideally I wanted the sums by date to be displayed horizontally and not vertically as shown in the picture, but was unable to do so. Anyways, I want to be able to filter those dates, so I can display data just from an specific date, and then change this date whenever I want and the new data will show up.

I tried doing by the checkbox that appears under the "data" dropdown on top of the column; However, when I uncheck a specific date, it dissapears and I have to add it again if I want to see it. Is there a way to keep the values on the dropdown even after I uncheck them? Or even another way to filter the information? Below is the pic of the dropdown I get when trying to sort the data, But as I said If I uncheck one of the values, it dissapears from the list.

[URL] ........

View 5 Replies View Related

Locking Different Cell Ranges Then Locking Whole Sheet With Macros

Jan 4, 2010

I have been assigned the task of creating our new integrated time and leave sheet in Excel 2007, previously we had 2 sheets, one for times and one for leave.

The problem I have is that I need to protect the authorisaton columns therre are 2 one for AM and one for PM, so that only Managers can authorise leave by inputting a password and then initialing the leave.

What I then need to do a the end of each month is for the manager to be able to click a Button with a Macro which will then lock the whole worksheet so that employees cannot change their times after the manager has checked the sheet.

I can lock the authorisation columns and password protect but I have to enable protection on the sheet, when I do this I cannot then figure out a way of running a macro which will then protect the whole sheet and assign a password to it so it cannot be changed after being checked and signed off.

I have tried to create a macro (button) to remove the protection on the 2 columns and then reapply protection to the whole sheet with another button but to no avail.....

If anyone has any suggestions I would be eternaly greatful.

Passwords on the sheet for the different buttons are abc or cobra.

You can download my Spreadsheet here.


View 9 Replies View Related

Locking One Cell If Another Had A Value In It (conditional Locking)

Oct 10, 2008

I recently posted a thread on locking one cell if another had a value in it, and vice versa for the other cell. I got this great response (thanks se1429!) and it works GREAT, but I failed to mention that the worksheet is password protected. It asks for a password when I enter a value in one of the cells. I just need help adjusting this code so I can put my password in the code and allow the worksheet to unlock and lock at will by using this password.

View 9 Replies View Related

Freeze Top 2 Panes

Jan 15, 2009

I tried highlighting the top 2 rows and clicking 'freeze panes' but it didn't seem to freeze correctly

View 3 Replies View Related

Freeze Panes

Nov 20, 2009

Just wondering if I can lock a worksheet to display the content within the window only. Eg 22 Rows by 6 Columns? Therefore stopping people tampering or moving objects?

View 10 Replies View Related

Freeze Panes Using VBA

Nov 3, 2009

I'm trying to get one of my macros to freeze panes in several worksheets. For some reason though, sometimes it freezes the panes in the wrong place. What could be causing this? My code basically looks like this:

View 4 Replies View Related

Freeze Specific Panes?

Jan 28, 2013

Is there a way to freeze specific panes? I know that you can use freeze panes to freeze cells to the left and above a specified cell but I am trying to freeze specific cells. For instance I want to freeze cells A1 through K25 so that when I scroll up everything else scrolls up and when I scroll right everything else scrolls right?

View 2 Replies View Related

Freeze Panes VBA Without Select

Oct 12, 2007

Anyone know if it is possible, in VBA, to freeze the panes of a worksheet at a specific cell without selecting that worksheet or the cell.

View 9 Replies View Related

Freeze Panes In 2 Places

Dec 18, 2007

I'm looking for a solution to freeze panes twice. That is I want to freeze row 1-15 and row 200-203. And then the rows 16-199 to be movable. In the first 15 rows I have column info so I need that visable all the time and in row 200-203 I have " Sum" of the lines 16-199 so that's why I want that to also be visible at all time. The ordinary freeze pane in excel just freezes at one certain horizontol point and I need 2. Can it be done with VBA maybe? Is it possible to insert an up/down arrow (the one you have at the right side of the screen, don't now what it's called) for the lines 16-199?

View 3 Replies View Related

Dragging Vertically

May 27, 2009

In row 3 I have values horizontally. (A3 to Z3)

i link C5 to A3.
If I drag it vertically it does not give the correct values.
Is it possible to drag it in a correct way?

I tried =INDEX($A$3:$X$3,ROWS($A$3:$A3))

View 9 Replies View Related

Split / Freeze Panes On Two Sides?

Jul 18, 2014

I want to change looks of my workbook with freezing columns on left side, and columns on right side. Between are days of months, where I want to use scrollbar.

I know I can freeze only on one side, but don't know how this Split option really works.

See this screenshot, that's how I want It to look (brown colour for columns that need to be frozen)

View 3 Replies View Related

Freeze Panes - Specific Cells

Dec 6, 2012

How to use freeze panes? I am trying to freeze specific cells and all I seem to be able to do is freeze the top half of the spreadsheet.

View 2 Replies View Related

Freeze Panes Toggle Button

Sep 11, 2009

I have a sheet in which I am using freeze panes to keep the header section always visible. I would like to be able to add a toggle button with a macro to the sheet to allow the user to turn the existing freeze panes on/off at will, without the need to navigate the menu bar itself. So far I have not been able to find any info on if/how this may be possible. If anyone has any experience controlling freeze panes via macros, etc.

View 3 Replies View Related

Freeze Panes Code Not Working.

Oct 27, 2009

Freeze Panes Code not working.
Below is the code im not sure whats up with it?

View 3 Replies View Related

Freeze Panes When Scroll The Rows

Nov 5, 2009

If is possible to create any info about freezing panes. I mean, when is pan freezed, and rows are scrolled in lower part of table (upper data are not vissible) if is possible display/show any text about this (e.g. "The first line of table are not visible")...but only if is not the upper part of data visible..not always.

View 5 Replies View Related

Freeze Panes With Columns Hidden?

Oct 30, 2013

I know you can't delete columns permanently in a worksheet so I am hiding them. Attached is an image of how many I want. My issue is that the dividing line that is used to freeze a top row pane is still extending across the entire worksheet (which has whitespace on the right side).

I suppose I could always extend my formatted worksheet to be the size of the screen.

View 1 Replies View Related

Disable Freeze Panes And Sort?

Oct 5, 2007

Is there a way I can disable Window > Freeze Panes and Data > Sort from a shared workbook?

View 9 Replies View Related

Split Panes Vertical Scroll Bar

May 18, 2009

I have used split panes to show two copies of my screen side by side/left and right.

There are already two horizontal scroll bars on the bottom - one on each pane. There is only one vertical scroll bar on the right side of the right pane.

Two questions:

1. Can a VERTICAL scroll bar be added to the right side the left pane so that each pane can independently be scrolled up and down without the other pane scrolling simultaneously?

1. Is there a way to remove these HORIZONTAL scroll bars on the bottom?

View 9 Replies View Related

Invert The Effect Of Freeze Panes

Jun 13, 2007

I would like to freeze the bottom part of my spreadsheet, such that the user can scroll through the upper part but still be able to see the bottom part. The freeze command freezes what is above the line, I want to freeze what is below the line.

View 4 Replies View Related

User Defined Task Panes

Dec 10, 2007

Is there a way to create user defined task panes from vba ?

View 4 Replies View Related

How To Display Data Vertically

Sep 9, 2013

How can I submit the data from userform in the spreadsheet vertically like A1,A2,.....

View 9 Replies View Related

Excel 2003 :: Enable Freeze Panes

Dec 13, 2013

How to enable freeze panes, I am running excel 2003, I have no hidden workbook and I have followed the video that explains how to freeze panes, but it remains greyed out and I just cannot enable it..

View 1 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved