How To Freeze Specific Block Of Cells
Sep 18, 2013I want to freeze rows 1-18 and columns A-P. But when I select the the cells and choose freeze panes but what it freezes is Rows 1-13 and columns A-H.
View 1 Replies
ADVERTISEMENT
Freeze Panes - Specific Cells
Dec 6, 2012How 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 RelatedFreeze Specific Panes?
Jan 28, 2013Is 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 RelatedHow To Freeze Specific Ranges In Formula All Together
Dec 12, 2013I want to freeze the formulas (F4) in whole column in Microsoft Excel, Is it possible to freeze together, not to freeze one by one. I freeze it one by one but that's actually a pain when you have hundreds of formulas to freeze.
View 7 Replies View RelatedFreeze Panes Via VBA Selects Wrong Freeze Point
Jun 1, 2012I have a macro which I recorded, then modified. The first thing it does is to freeze the top row, then it goes looking for a particular row and inserts some formulae. Nothing complicated at all.
It WAS working perfectly, but I wanted some improvements in the insertion of the formulae. I got that working just fine, but now the panes freeze in the wrong place. No matter what I do, it freezes at cell I16. I want only the top row frozen.
Found this code which was reported to work:
PHP Code:
    ActiveWindow.FreezePanes = False    Range("A1").Select    ActiveWindow.FreezePanes = TrueÂ
It still freezes at I16. I have tried shutting down Excel, and even my computer, in case it is some weird bug where something is stuck in memory.
I tried recording another macro to format some cells and also freeze the top row. Same result.
PHP Code:
Sub wraptext_top_row()'' wraptext_top_row Macro''   Â
Rows("1:1").Select    With Selection       Â
.HorizontalAlignment = xlCenter       Â
[Code] ..........
Same result. I tried copying the contents of the worksheet to Notepad, then into a fresh workbook, just in case there's some weird hangup in formatting that I can't see.
There is NOTHING in the original code that references that cell, or even that row or column. NOTHING. How it got hung up on that one cell I cannot fathom.
The Freeze Panes command works normally if I apply it manually. Any cell, anywhere, it works as expected.
Blanking Cells Within Block Of Cells If Date Parameter Has Not Been Met?
May 30, 2014Sample Chart.xlsx
I need to enter data every month for the following month (i.e. month end close, for previous month). For this example, let's say I just entered (in May) data for April. Current year is 2014. The attached above is what I have currently, and what I want to achieve. All of the cells have formulas, but I basically don't want data and variances shown for time periods not yet uploaded, so in my example, I should only see filled-in cells for January-April, and not May-December (keep in mind that 2013 data should remain, as these are time periods in the past). I've thought about many scenarios including: modifying the formula but not changing what it is currently doing (essentially gathering and adding data from a different worksheet), conditional formatting to "white out" all cells for months where 2014 data is not available using NOW or similar function. how to do it most efficiently without disrupting what's currently in place. T
Freezing A Block Of Cells
Jun 16, 2009I need is for a block of cells (A1:I4) to be visible at all times. I've frozen the sheet so that the top four rows are always visible, but unfortunately the sheet is quite large, horizontally-speaking, so that when users scroll horizontally, important stuff scrolls off the screen.
View 9 Replies View RelatedInserting A Block Of Cells Using An If Statement
Jun 26, 2008task of inserting a block of cells into a worksheet.
I have saved 4 different blocks of cells and depending on an option chosen from a drop down menu i want to select one of more of these sets of data and paste them into a worksheet.
Sum / IF Function Resulting To Calculation Of Block Of Cells
Jun 3, 2014I have quarters of the year. I'm wanting to find a function wherein when I punch in for example year 2012, the cell would give me the sum of the 4Qs. If if change it to 2013, then it would give me the sum of 4Qs for 2013.
See attached sheet : sum from blocks of cells.xlsx
Format Multiple Cells Into Address Block?
May 3, 2013how I can get this:
John Smith
1 Aisleby Avenue
Nottingham
Notts
NO1 1ON
i.e. each line in it's own cell
to look like this:
John Smith
1 Aisleby Avenue
Nottingham
Notts
NO1 1ON
In other words, an address block in a single cell. Simple merging only saves the first cell's contents.
I need to do this for 500 addresses
Autofilter Block Of Data From Active Cells Offset
Jul 16, 2012Thats the best I could describe that What I face today is the means to run a VBA Autofilter from an Activecell. The Activecell is a search result. I have a table that spans from A1 to E5000. The Activecell will always be in Column A. What I need to happen in when the Activecell is found an Autofilter is placed in the block of data from Column B to E. The rows will change after every search hence my dilemma. Each block of data has its own header as well
So if my Activecell is A2 then I need B1:E4 Autofiltered then Column E sorted Smallest value to Largest. The Activecell needs to remain static. The size of the blocks of data are exactly the same.
Here is a photo example of the desired result. Untitled.jpg
There are hundreds of blocks of data like this.
How To Count And Report Instances Of Text In Block Of Cells
Feb 17, 2014I have a workbook consisting of two sheets: a Monthly Class Schedule (Divided into five one-week blocks. Each block's vertical is Mon to Fri, the horizontal is 9 class slots. There are 45 class slots pw). Each class has one student and the cells are filled 'Student Number, First Initial, Surname' eg, '666 J Smith'. Students may be scheduled for several class slots per week and some class slots have no students scheduled. When the student attends a 'P'is added at the beginning of the cell eg,'P 666 J Smith'.
The Student Attendance Report has the students listed vertically on the left, arranged by Student Number, and then a column for each week.
At the moment I have to manually count the classes each student has attended for each week and enter the attendance figures in the appropriate week column. It's a PitA so I want to automate the process by using the S#s in the Attendance Sheet to search the week blocks in the Schedule Sheet for 'P S#' and auto-fill the week columns in the Attendance Sheet.
Sched and Attend February 2014.xls
Excel Block Hidden Cells When Paste In Another Workbook?
Feb 21, 2014How can I block the hidden cells, so that when I want to copy/paste into another workbook, pasted data has to be all, except hidden&locked cell?
View 4 Replies View RelatedConditional Formatting Formula Used To Turn A Block Of Cells Green
Jan 27, 2010I have attached a small file with a very simple conditional formatting formula used to turn a block of cells green.
However, the formula does not seem to work properly as it only turns half of the cells green. Columns B1 to B18 are also supposed to turn green, but instead remain clear.
Macro To Copy Specific Cells From Row From Source & Stop When Next Row Cell = Specific Value
Nov 7, 2008I have a protected template and unprotected source worksheets - - - what I would like to happen is for the macro to start and if the source worksheet cell B3 equals "Report Total" then stop - otherwise copy template worksheet then copy 6 specific cells from the source to paste values to specific cells on the newly created worksheet (B_ to C7, D_ to I7, E_ to C9, F_ to K9, A_ to C11, M_ to K11 and then K13=F13-30)
After that then start all over again unless the next row’s cell (B4, B5, B6, . . .) is "Report Total" then stop - - - the row count could be from one to a couple hundred.
Here is what I have so far but I know that with each copy the name will change and as it goes down the source file each row will change and I also need help with that.
Sheets("ee template").Copy After:=Sheets(3)
ActiveSheet.Unprotect
Selection.ClearContents
Range("I7").Select
Selection.ClearContents
Range("C7").Select
Sheets("source").Select
ActiveCell.Offset(0, -11).Range("A1").Select
Specific Cells Populate With Specific Numbers When A Value Within A Range Is Entered
Oct 9, 2009Here is what i am trying to achieve. If the date 2/20/2010 is located at F53 & the cell next to it at H53 is populated with a number between 1 & 16, then i want the cell at J11 (42 rows further up) to auto populate with the number 1. When this occurs the cells beneath this, from J12 to J52 should also auto populate with the with consecutive numbers from 2 to 42. Would also like to see the cells with numbers 1 to 28, automatically format to orange & the cells containing numbers 29 to 42 automatically format to yellow. I plan to have this condition repeat several times later in the year, at dates that are to be decided. When these dates are decided i want to be able to enter a number from 1 to 16 & next to the date & all of the above automatically occurs.
View 14 Replies View RelatedHighlight Specific Cells In Row If >1 Contains Specific
Apr 30, 2007I'm trying to use a conditional format on a range of cells so that if there is more than 1 "A" contained in any given row, the cells containing the "A"s are highlighted (e.g. red)
I've tried:
=COUNTIF(B2:K4,"A")>1
but it doesnt work & now I'm stuck.
Trying To Freeze A Sheet
Dec 17, 2007I have multiple sheets as part of my excel calculations which refer to the first sheet in the group. Each one calculates different values for me based on the numbers I put into the sheet.
So to put in these numbers, I insert new rows to the start of the sheet which is what I always want it to calculate. Some of the calculations are comparative to other points from my original page. So I might ask it to go back and compare to 3 months ago or 6 months ago.
Long story short, when I insert those new rows, the formula on the other pages shift down to stay on the previous days data. How can I lock it in so it stays focused on just the cell I tell it to reguardless of how I move those cells around. So when i hit insert, I still want it focused on that sheets A1 and NOT A2.
I attempted to look up the help section but since I am having a hard time putting this into words, help was not much "help".
Freeze Top 2 Panes
Jan 15, 2009I tried highlighting the top 2 rows and clicking 'freeze panes' but it didn't seem to freeze correctly
View 3 Replies View RelatedFreeze Panes
Nov 20, 2009Just 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 RelatedHow To Freeze Only One Cell
Nov 23, 2013i want freeze only one cell. I have a button. I want keep that button permanently in a place. i am planning to freeze a cell where the button is located.
View 3 Replies View RelatedFreeze Panes Using VBA
Nov 3, 2009I'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 RelatedVba Printpreview Freeze
Jul 7, 2006when ever it runs it brings up the print preview of the correct sheet (looks just like i wanted) but the vba object stays infront of the print preview window and locks up i cannot close it and cannot access the print preview window because it is blocked by the vba object even though i can see the print preview in the backbround.
i have tried asding "unload me" after the "activesheet.printpreview" line but does not make any differnce i end up having to close excel via task manager and reopen it.
Private Sub cmdPrtPreview_Click()
On Error Resume Next
Sheets("invoice").Select
ActiveSheet.PrintPreview
End Sub
Lookup Range Of Cells And Populate Specific Cells Based On Matching Data?
May 23, 2014I am trying to build a staff roster. The staff rotate over a 4 week cycle. the name of the staff member, and their shift needs to be looked up from the key then matched with the particular week. the name and shift then need to populate specific cells.
I have attached the worksheet so you can see what i am trying to achieve.
Excel 2010 :: Color Fill A Range Of Cells If Specific Cells Not Blank
Feb 7, 2013I am using Excel 2010 and basically i am trying to fill a range of cell with a green color if any value was enter in a specific cells. Example: I would like to fill range: A10:c13 with a green color (regardless of the cells content in this range) if a value was entered in cell C10 or C11 or C12 or C13.
I've tried conditional formatting but unfortunately I'll have to apply formatting for every cell and for a range of over hundred cells is not efficient.
Forcing Cells To ALWAYS Find MIN And MAXIMUM Values From A Specific Range Of Cells
Feb 1, 2010I'm working on a project for my company. We make plastic tanks and for quality control we want to start recording the thickness of the tanks in different areas/zones of each tank.
Attached to this message is an Excel sheet that I've been working on. From "Sheet 1", it records inputted thicknesses into WorkSheet "1098". On the top of "1098", it shows all of the recordings, and just below that are the "10 Most Recent Entries".
Right below the "10 Most Recent Entries", there are formulas to calculate the Min and Max Values. Whenever a new entry is recorded, the selected cells for the Min and Max formulas change. Is there a way to force the cells to always stay the same?
Highlighting Cells If Specific Data Appears In Adjacent Cells
Mar 18, 2014I have a couple of spreadsheets that has several columns each containing several hundred thousand rows of codes. To quickly analyze this data, I am trying to come up with a conditional formatting formula to highlight the respective cells when specific values occur next to each other. A particular code will show up in many cells, but the code that is the respective adjacent cell is always different. I need to know when row A contains, for example, '9928559' and row B contains '36415RT'.
View 3 Replies View RelatedFreeze The First Column On My Spreadsheet
Oct 16, 2009I am wanting to freeze the first column on my spreadsheet (easy) but also the top few rows. Every time I try (am using 2007) it seems to make a strange selection where it splits the screen exactly into 4 equal parts rather than just the first column and top 4 rows.
View 3 Replies View RelatedAuto Time Freeze
Feb 8, 2006I have a long sample list, (names and telephone no.), once a name and number
are used an outcome code is entered in the end cell like so ...
Freeze Rows AND Columns
Sep 6, 2009Is there a way to freeze both rows and columns? I want to freeze the first five rows 1-5 and columns A-C and have the ability to scroll while having thee rows/columns static?
View 7 Replies View Related