Contact Us
Sign In / Sign Up for FREE
Go to advanced search...

Programming MS Excel to freeze panes - Article Example

Comments (0) Cite this document
Freezing panes facilitates the locking of these rows or columns (Johnson, 2007. The aim is to keep particular columns or rows visible…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER97.2% of users find it useful
Programming MS Excel to freeze panes
Read Text Preview

Extract of sample "Programming MS Excel to freeze panes"

Programming MS Excel to freeze panes Insert Insert Introduction Freezing panes is the process whereby a section of the worksheet remains constant while you are scrolling other sections of the same worksheet. Freezing panes facilitates the locking of these rows or columns (Johnson, 2007. The aim is to keep particular columns or rows visible when scrolling. To freeze the top row containing headings, you need to select the row then click on menu view. You then select freeze top menu under the submenu freeze panes. Meanwhile, to freeze a number of rows, select the rows then under the freeze panes submenu, you select freeze panes. The same applies to when applying to more than one column. However, to implement freezing panes on the first column, you choose the first column under the freeze submenu. After using the freeze panes, in either case, you remove by selecting unfreeze panes.
The purpose of using freezing panes is to maintain your track on cells, and rows or columns of data that you feel are vital when making navigations through the worksheet. Further, it is very vital when working with an extreme number of rows and columns. It is so because irrespective of where you are scrolling, the headings will always be visible thus making it easier to relate where the data belongs. The user is said to remain in perspective with the data concerned.
Freezing panes differs from the views in the database. First, freezing panes aims to keep a section of the worksheet visible i.e. keep its state constant to allow the user to relate to other parts of the worksheet especially when there are many columns and rows involved. Views, on the other hand, retrieve information from data store that meets the particular criterion. In essence, database views are more flexible (Lightstone, Teorey & Nadeau, 2007). The results it can return is custom to users needs and covers a wider scope as compared to freezing panes in Excel that has a predefined way of using it. Further, freezing panes is strictly restricted to navigation where some section is mobile while the others are constant whereas views deal with data.
Johnson, S. (2007). Microsoft Office 2007 on Demand. Indianapolis, IN: Que Pub.
Lightstone, S., Teorey, T., & Nadeau, T. (2007). Physical database design. Amsterdam: Morgan Kaufmann/Elsevier. Read More
Cite this document
  • APA
  • MLA
(“Programming MS Excel to freeze panes Article Example | Topics and Well Written Essays - 250 words”, n.d.)
Retrieved from
(Programming MS Excel to Freeze Panes Article Example | Topics and Well Written Essays - 250 Words)
“Programming MS Excel to Freeze Panes Article Example | Topics and Well Written Essays - 250 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Programming MS Excel to freeze panes

Excel Project

Software prepared by the most prominent software company Microsoft are: Microsoft Dynamics GP Microsoft FRx for financial reporting and analytics Microsoft Office Small Business Accounting 2007 Microsoft Small Business Financials SAP manufactures: SAP ERP Financial Solution SAP Intuit Company prepares: Quickbooks, Quicken TurboTax Industries All these software are used by organizations which have huge database and it is not easy to manage it without appropriate software, for instance multinational companies, banking systems and airport terminals etc. Apart from these industries, all these software are marketed also marketed to renowned websites like, Reuters and Bloomberg. Wall Street & Firms Generally Wall Stre...
6 Pages (1500 words) Essay


... in the program. b) void Time::setTime (int hh, int mm, int ss); { hour = (hh>=0 && hh<24) h :0; mnute = (mm>=0 && mm<=60) m : 0; second = (ss>=0 && ss <60 ) s : 0; } Time::Time() { hh=mm=ss=0; } c) Int Time::timesAreEqual (Time &tl, Time &t2); { if ( t1.hour= t2.hour && t1.minute == t2.minute && t1.second == t2.second ); return 1; else return 0; } Question 28 a) A pointer is a variable that holds some memory address. b) An array in C++ is a variable that holds subsequent memory locations up to the number declared by the user. The first element in the array has the index 0. d) when the statements q1 = &x; and q2 = &y; are executed pointer q1 get the value of x and q2 gets the value of y. x 78 y 96 x=78 y=96...
9 Pages (2250 words) Research Paper


The determination of Se should be done by ICP-MS and not by DRC mode because the response obtained for Se 82 in DRC shows lower response as compared to good counts in ICP-MS. The chances of error are less when ICP-MS is employed for estimation of
3 Pages (750 words) Lab Report

In excel:

...My Business and Number of Answer Report For any business to realize an increase in profits at the end of a given duration, quite a number of factors can be varied. Two parameters were chosen for this business model and that is: sales and cost of sales while maintaining all the other factors constant, e.g. those relating to customers. To do this, a spreadsheet named “Profit Analyzer” was created that projects the expected profits depending on how these two chosen parameters are expected to vary quarterly i.e. their percentage rate of increase or decrease (Ken Kaufaman, 2010). When a percentage rate of change is entered under the “Variations” column for either of the two parameters, say 105% if sales are projected to increase... Business and...
2 Pages (500 words) Essay


...Logic and Programming Programming A problem Analysis Chart Given information The information provided is that children below 18 Years of age should not be considered as customers for purchases. Required Results Processing required Solution Alternatives The only alternative is to use the “if” condition to test whether the age is greater than, equal to or less than 18. 2. A flowchart 3. A chart showing input, output, and processing Year of Birth YOB Year Today YT Age (YT-YOB) Status Accepted / Rejected 4. Algorithm (Pseudo code) using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication3 { public partial...
1 Pages (250 words) Essay


...INFS 3100 EXCEL ASSIGNMENT DUE: Wednesday, February 11 (beginning After 12:50 pm the assignment is considered a day late. See syllabus for late policy. Helpful Hint: Don’t forget to “Lock Cells” (Use absolute cell references) as needed when doing calculations for this assignment. Instructions: (use formulas or functions unless otherwise noted) 1. Download and open the template found on D2L. (Filename: 3100 Excel Assignment 1 Outline Spring 2015) 2. Set the value of the January “Beg. Of Month Inventory” equal to the “Initial Inventory” Cell. 3. Set the value of January “Production” equal to the “Initial Production” Cell. 4. Set the value of January “Units Sold” equal to the “Initial Units Sold” Cell. 5. Management predicts...
1 Pages (250 words) Assignment


But if the average is considered, then S & P 500 is a better company to invest in.
Mean and median are two types of averages and are the most common. Mean is the average which is realized when you add up all the numbers and then divide by the count of the numbers, in this case after calculating the mean value for each of the firms, we realized the following data outputs, Abbots Laboratories 34.51503, Unilever realized a mean of 37.05433 while S & P500 realized a mean of 1654.891. The median is the middle value in the list of various numbers, to obtain median the numbers are listed in numerical order, after calculations we realized the following data, Abbotts Laboratory a median of 34.75, Unilever realized a median of 38.11 and...
11 Pages (2750 words) Essay

Report* NEED sensitivity analysis(MS Excel data tables) and break-even analysis(MS Excel Solver or Goal seek)

...INTRODUCTION TO FINANCE Project Report May 12, Executive summary: As the granny flat has a positive NPV (Net Present Value) of $10144.73, s the IRR (internal rate of return) is greater than Required Return. IRR is at 13.48% (12372/91750*100) which is greater than the required return of 4.51%. This investment has a payback period of 8 years. As this granny flat has a greater than required Rate of Return, and a large NPV, the construction of this granny flat should go ahead, as it is a good investment. Q2) Rental Revenue renting for whole granny flat with 2 bedrooms- $455. Electricity bill- $350 per quarter which is taken from the average of small (3500kWh pa) household scenario.(insert grapgh) Water bill Per week- $27.22 Service...
2 Pages (500 words) Essay

MS Excel and Access in Financial Calculations of Business Operations

... Flyguys Project Report Part 1 Flyguys has several requirements that can be met through proper usage of Access and Excel both. However, each of those software has its own pros and cons. Flyguys is interested in implementing a system that enables them to achieve three major goals; record keeping, reward system and reporting. This report takes a look at each of these requirements separately and identifies and analyzes the ways in which MS Office can come to Flyguys’ rescue. MS Office is replete with options and ways to facilitate record keeping (Couch, 2013). Flyguys wants to keep records in a system which allows them to update, append and delete the records when necessary (FLIGHT MANAGEMENT COMPUTER, 2015). These records are mainly...
8 Pages (2000 words) Coursework
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Article on topic Programming MS Excel to freeze panes for FREE!

Contact Us