increase the number of rows or columns in a worksheet, Computer Engineering

How can I increase the number of rows or columns in a worksheet?

Ans) In Excel, each workbook has 255 columns and 65,526 rows. These values are fixed and cannot be changed. If you require more rows, you might require considering using a database (such as Access) or one more spreadsheet (Quattro Pro can handle a million rows) for data storage. In most cases, you probably don't require to work with all of your data at once. You'll usually require only a subset of your data. You can use Excel's Data, Get External Data command to query the database and bring in only the records you require.         

 

 

Posted Date: 4/4/2013 2:04:54 AM | Location : United States







Related Discussions:- increase the number of rows or columns in a worksheet, Assignment Help, Ask Question on increase the number of rows or columns in a worksheet, Get Answer, Expert's Help, increase the number of rows or columns in a worksheet Discussions

Write discussion on increase the number of rows or columns in a worksheet
Your posts are moderated
Related Questions

What do you understand by Electronic Funds Transfer?  Electronic Funds Transfer: It's an electronic payment method that transfers the money value from one bank account to

Advantage of wrapping database calls into MTS transaction If database calls are complete within the context of a transaction, aborting the transaction will undo and changes that

Enumerate the Design reusability of VHDL VHDL.  Functions  and  Procedures  may  be  placed  in  a  package  so  that  they  are  available  to  any design-unit which wishes t

Q. Describe Big Notation? Big O Notation : The set O (g(n)) comprises all functions f(n) for that there exists   positive constants c such that for satisfactorily large values

E Brokerage facilitates search & retrieval of Information The success factor of a brokerage is its ability to retain existing clients and to enhance their satisfaction by effec

Q. Illustrate Decimal Fixed Point Representation? The point of this representation is to keep the number in decimal equivalent form and not binary as above. A decimal digit is

Explain the principle of duality with examples.

Single Instruction and Single Data stream (SISD) In this organisation, sequential implementation of instructions is executed by one CPU having a single processing element (PE

I''m seeking a challenging professional working position in the field of Information Technology,where I’ll be given the chance to enhance & expand the skills & experience