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
Companding helps in reducing with respect to signal:  (A) Interference                    (B) Signal overloading (C) Non linearity                 (D) Quantization noise


The difference among the next and continue verb is that in the continue verb it is used for a situation where there is no EOF condition that is the records are to be accessed again

Explain the transport layer in detail. Transport Layer: The transport layer controls and makes sure the end-to-end integrity of the data message propagated by the network am

Q. Explain Arithmetic Data Processing Instructions? These instructions carry outlogical and arithmetic operations on data. Arithmetic: The four fundamental operations are

An 8086 interrupt can take placedue to the following reasons: 1.  Hardware interrupts caused by some external hardware device. 2.  Software interrupts that can be invoked wit

In binary counter the flip flop of lowest order position is complemented with each pulse. This means that JK input position must be maintained with logic one

Using Module-Instance Parameter: Parameter values can be overridden while a module is instantiated. New parameter values are passed at the time of module instantiation. Top-

What are the functions of passes used in two-pass assembler? In an assembly language program, two pass translations can handle forward references early. The subsequent task

Q. How to Transmits data in the active message buffer? int pvm_bcast( char *group, int msgtag ) Transmits data in the active message buffer to a group of processes. msgt