The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,769 other followers

Archive for the ‘Office 2011 for Mac’ Category

How to Extract a Number or Text from Excel with this Function

Posted by jpluimers on 2019/11/11

Lots of fuzz, but the formula towards the end worked:

=SUMPRODUCT(MID(0&A1,LARGE(INDEX(ISNUMBER(--MID(A1,ROW($1:$25),1))*
ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)

Source: [Archive.isHow to Extract a Number or Text from Excel with this Function

More of those at [WayBack] Extract Only Numbers From Text String

–jeroen

Posted in Excel, Office, Office 2011 for Mac, Power User | Leave a Comment »

Resize a table in Word or PowerPoint for Mac – Office Support

Posted by jpluimers on 2019/11/08

Why does it take forever for Microsoft Office suite programs to function the same across their various components and over operating systems. It has been like 2 decades and still sizing columns/rows in tables is a nightmare.

[WayBack] Resize a table in Word or PowerPoint for Mac – Office Support.

In my case PowerPoint: it is so different from Excel, and even different from Word, that it gives me headaches.

This is what PowerPoint 2011 could do; more recent versions are only marginally better:

PowerPoint

You can resize a whole table to improve readability or to improve the visual effect of your document. You can also resize one or more rows, columns, or individual cells in a table.

Do any of the following:

Resize a table

  1. Click the table.
  2. Rest the pointer on any corner of the table until Table Resize Cursor appears, and then drag the table boundary until the table is the size that you want.

Change the row height in a table

  1. Rest the pointer on the row boundary that you want to move until Horizontal split arrow appears, and then drag the boundary until the row is the height that you want.

    If you have text in a table cell, the row must be the same height or taller than the text.

Change the column width in a table

  1. Rest the pointer on the column boundary that you want to move until Vertical split arrow appears, and then drag the boundary until the column is as wide as you want.

    If you have text in a table cell, the column must be as wide as or wider than the text.

Change the row or column to fit the text

  • Rest the pointer on the column boundary until Vertical split arrow appears or the row boundary until Horizontal split arrow appears, and then double-click it.

Make multiple rows or columns the same size

  1. Select the columns or rows that you want to make the same size, and then click the Table Layout tab.
  2. Under Cells, click Distribute Rows or Distribute Columns.

    Tables Layout tab, Cells group

–jeroen

Posted in Office, Office 2011 for Mac, Power Point, Power User, Word | Leave a Comment »

Excel on Mac OS X: Insert, move, or delete page breaks in a sheet

Posted by jpluimers on 2019/08/16

Since I always get confused by the differences in Excel versions (not just between Mac OS X  and Windows):

In Excel for Mac, you can adjust where automatic page breaks occur, add your own page breaks manually, and remove manual page breaks.

Source: [WayBackInsert, move, or delete page breaks in a sheet.

–jeroen

Read the rest of this entry »

Posted in Excel, Office, Office 2011 for Mac, Power User | Leave a Comment »

Excel: printing top row on every page, and including grid

Posted by jpluimers on 2019/06/28

I hardly print with Excel, so I always forget these two:

–jeroen

Posted in Excel, Office, Office 2011 for Mac, Office 2013, Power User | Leave a Comment »

ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different

Posted by jpluimers on 2019/06/10

Via [WayBack] ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different a few keyboard tips.

Lets start with the shortest one:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press space
  3. Press CommandZ or ControlZ to undo the change

This probably is unintended, but works great: all text is now selected, so you can copy/cut with Command-C/CommandX.

Now the “official” way:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press ControlU or F2 to edit the cell (the cursor is now at the end)
  3. Press ShiftAltHome or ShiftControlHome (to select all text)
    note: Home can also be FnLeft.

Other selections you can make while the cell is in edit mode:

  • Press ShiftAltEnd or ShiftControlEnd (to select to the end of the cell)
    note: End can also be FnRight.
  • Press ShiftAltRight or ShiftControlRight (to select one word to the right)
  • Press ShiftAltLeft or ShiftControlLeft (to select one word to the left)
  • Press ShiftAltDown or ShiftControlDown (to select to the same position on the line below)
  • Press ShiftAltUp or ShiftControlUp (to select to the same position on the line up)

Keyboard symbols (more at [WayBackCommand, Option, & Shift Symbols in Unicode):

  • Shift
  • ^Control
  •  – Alt which is the same as Option
  •  – Command
  • Fn – Function

–jeroen

Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, macOS 10.12 Sierra, Office, Office 2011 for Mac, Power User | Leave a Comment »

 
%d bloggers like this: