Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Is it me? (Excel)

Apr 27, 2005 8:32PM PDT

Is it me? Or are there really very few questions on Excel problems in this forum any more?

I'm no expert on Excel, self taught which perhaps is the worst sort of expert, Happy but I used to enjoy tackling some of the problems that were posted, or reading other peoples' solutions.

Ahh well. Perhaps everyone has become an expert now with all our good advice and help in the past!

Mark

Discussion is locked

- Collapse -
Excel problems
Apr 28, 2005 12:52AM PDT

OK, Mark. I am a pre-beginner with MS Excel 2002. The question: How do I "select all" at a worksheet like I am able to do so with MS Word, so as to format fonts, cells, etc. "at one go" ? It may be very simple to do so, but I do not know it. I am only able to "select" individual cell, row or column, or select a section of the worksheet by draging from one cell to the cell of the opposite corner....

- Collapse -
(NT) Control-a or that topleft square of the sheet?
Apr 28, 2005 1:11AM PDT
- Collapse -
Damm
Apr 28, 2005 4:52AM PDT

Waiting for sooooo long for an excel question and I get beaten to it!!

Bob is right of course. Just above row 1 and just to the left of column A is a square. Click that and it highlights the whole worksheet.

Mark

- Collapse -
Thanks, Bob, and Mark-
Apr 28, 2005 8:04AM PDT

that little square looks so innocent. There should have been a "Select All" at the Edit menu; but come to think of it, it is logical- that square selects all rows and all columns. I should have thought of that. Thanks again.

- Collapse -
You're welcome Papa
Apr 29, 2005 10:12PM PDT

and that's what Bob says as well, Happy

Mark