How to reformat c2-00 pinouts

Excel sucks ...

Tag Archives: Cell Formats

I measured it again: I'm great.

Heinrich! I dread you. (Goethe; Faust I)

Yesterday in the Excel training course, a participant came with a file. Can I have a look at it? - Clear! My first astonishment: The file was almost 10 Mbytes!

Quite large!

As feared, it took a long time to open.

A look at the status bar showed me that the file was 58,300 pages long!

58,300 pages?!?

With [Ctrl] + [End] to the last cell U1048576. This column was empty!

So back to U1. From there I marked with [Shift] + [Ctrl] + [End] to the last cell and deleted the content and format of the unneeded columns.

Everything must Go!

One look: “only” 29,150 pages left

only half as many leaves

When I asked whether she needed all the sheets, it was answered in the negative. So: From A10000 the "rest" of the table was marked down and also deleted.

Out with it!

And finally I noticed that different line weights and cell formats were used. Out with the formats; mark everything and reformat it uniformly.

But not like that!

And finally, not all consecutive numbers of the first four columns have to be entered - this can be done with the help of a formula that can be elegantly pulled down:

The result: 230 pages and a file that is only 610 bytes in size.

That looks better.

Frame line from the left or from the right?

There is a difference whether a line is formatted from the right to a column or from the left to the column to the right of it:

Frame line from the right to the left column

Frame line from the left to the right column

If the table is centered horizontally when printing (page setup):

The table is centered horizontally.

Then it is either exactly in the middle or the supposedly empty column is added:

The table is centered.

The table is almost centered.

 

 

 

Categories

Excel is annoying ... even offline

At the beginning of 2021 I revised my VBA exercise book:
From the content:
Operators, links and branches, loops, errors, dialogs, classes, calls and parameter transfers, self-generated functions, file access and XML, the object model of Word, Excel, PowerPoint, Outlook and Visio and the exchange between the programs
 
  • Paperback: 496 pages
  • Publishing company: Books on demand; Edition: 1 (February 24, 2016)
  • Language: German
  • ISBN-10: 3739207159
  • ISBN-13: 978-3739207155
  • Price: 18.00 euros

I have been organizing an Excel get-together in Munich since 2016. We all have a lot of fun doing it. The fun was unfortunately clouded in 2020 when we were no longer allowed to meet. So I organized the Excel regulars' table online. This book contains the presentations that I gave on the online Excel round tables 2020. It is a colorful mixture of amusing, interesting and amazing things about the Excel spreadsheet. The book starts with the number formats, describes the differences between Excel on the PC and on the Mac, explains why connected cells should be avoided, provides information on notes and comments, reveals "hiding places" in Excel, explains how to use VBA Data verification can "drill out", shows how data was visualized in a project with the help of diagrams and what difficulties there were with it, provides some information about the ribbon and reveals some VBA tricks. For 10 euros. ISBN-10: 3752666749 ISBN-13: 978-3752666748

And here the cover of my current Excel formula book. Revised in early 2020; 7th edition. Same price: 22 euros. ISBN-10: 3746064872 ISBN-13: 978-3746064871
I've revised my Excel book: more formulas, more examples. The ISBN number has remained: Excel: Calculating numbers Formulas: formulas, calculations and links in Excel by René Martin (Author) ISBN-10: 3746064872 ISBN-13: 978-3746064871 Unfortunately, I had to pay 22 euros because of the 576 pages raise.

My new Excel book has been published - 544 pages on the subject of numbers, arithmetic, formulas, functions, linking, puzzling, thinking, solving problems in and around Excel. All of my knowledge (okay - a lot of it). From explanations VLOOKUP, nested IF functions, and date calculations, to look-up & referencing, text functions, and statistics, to numeric integrating, iterations, and determinate calculations. I think there is something for everyone. Available in every bookstore: Excel: Calculating numbers Formulas: formulas, calculations and links in Excel by René Martin (Author) ISBN-10: 3746064872 ISBN-13: 978-3746064871
Incredible: the third book has already been published: A summary of the articles on this page that I wrote in 2017.

Available from any bookstore or internet bookshop:
  • Paperback: 196 pages
  • Publisher: Books on Demand;
  • Edition: 1 (February 22, 2018)
  • ISBN-10: 3746080797
  • ISBN-13: 978-3746080796
#####
The second book has now been published: A summary of the articles on this page that I wrote in 2016.
Available from any bookstore or internet bookshop:
  • Paperback: 336 pages
  • Publisher: Books on Demand;
  • Edition: 1 (February 8, 2017)
  • ISBN-10: 3743182548
  • ISBN-13: 978-3743182547
#####
Last year's book - the approximately 500 articles that I wrote here on this blog in 2015 have been published - as a book and e-book.

Available from any bookstore or internet bookshop:
  • Paperback: 600 pages
  • Publishing company: Books on demand; Edition: 1 (February 4, 2016)
  • Language: German
  • ISBN-10: 373923167X
  • ISBN-13: 978-3739231679
  • Size and / or weight: 18.9 x 3.1 x 24.6 cm
  • price: 19.00 euros
You can find a reading sample under: Excel is annoying
######################
At the beginning of 2016 I also published an exercise book on VBA:
 
  • Paperback: 496 pages
  • Publishing company: Books on demand; Edition: 1 (February 24, 2016)
  • Language: German
  • ISBN-10: 3739207159
  • ISBN-13: 978-3739207155
  • Price: 18.00 euros
You can find a reading sample under: Learning VBA

Tags