Pages

Search

Excel Can't Add Microsoft Office for Mac

TextNData Forums - Microsoft Office for Mac

Excel Can't Add Microsoft Office for Mac

Excel Can't Add

Posted: 03 Oct 2013 01:50 PM PDT

Salmon Egg <net> wrote:
 

I apologize for imposing on your valuable time. I suggest that you
put me into your killfile to prevent me from doing it again.

Again, I thank those who responded constructivly. I did not submit
numbers with the OP because I expected one of two responses: (1) You're
crazy, or (2) That's a known problem; in a really obscure circumstance
the SUM function fails. My expectation of (2) was extremely low.

Charli
--
Nobody in this country got rich on his own. You built a factory--good.
But you moved your goods on roads we all paid for. You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward. Elizabeth Warren (paraphrased)

Excel spreadsheet - one column into two columns

Posted: 25 Jun 2013 07:22 AM PDT

How to transpose / convert a single column to multiple columns in Excel?
Supposing you have a table as showing below, and you need to change one column to a range. Here we will show you some tricky things about how to change a single column into multiple columns.

Transpose a single column to multiple columns with formula

Transpose a single column to multiple columns with Kutools for Excel

doc-convert-column-to-rows1 arrow-big doc-convert-column-to-rows2
Kutools for Excel: Add 120 New Powerful Features to Excel.
Classic Menu for Office: Bring Back Old Look to Office 2010 and 2013 (includes Office 365).
Office Tab: Bring Tabbed Editing and Browsing Features to Office, Just Like Chrome, Firefox, Internet Explorer 8/9/10.
arrow blue right bubble Transpose a single column to multiple columns with formula

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!


In excel, the OFFSET function can help you, you can use this formula as following steps:

1. In a blank cell C1, please enter this formula: =OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*6,0), see screenshot:

doc-convert-column-to-rows3

Note: A1 is the started cell, *6 stands for the number of cells that you want to have in each row. Meanwhile you must start this formula in the columnC.

2. Press Enter key, and select cell C1, drag the fill handle from C1 acrossto H1, while C1:H1 are selected and then copy down as far as you need. Seescreenshot:

doc-convert-column-to-rows4

As they are formulas, when you copy them, you must copy and paste them as values.

There are some limitations of this formula, maybe, it is difficult for beginners to apply. Here I will continue to introduce you an easy way to deal with this problem.

arrow blue right bubble Transpose a single column to multiple columns with Kutools for Excel

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

After installing Kutools for Excel, please do as this:

1. Select the column that you want to convert.

2. Click Kutools > Range Converter > Transform Range, see screenshot:

doc-convert-column-to-rows5

3. In the Transform Range dialog box, specify the settings as follows:

Choose Single column to range from Transform type;
Specify the cells per row, if you have selected a column with blank cells as separator, you can check Blank cell delimits records, and the data will start a new row at each blank cell. You can also specify the number of cellsper row from the Fixed value that you need.
doc-convert-column-to-rows6

4. Then click OK, a Transform Range prompt box will pop out, and click a cell to put the result. The Output range can be specified in different worksheets and workbooks. See screenshot:

doc-convert-column-to-rows7

5. Click OK, you will see the single column has been transformed to multiple columns in selected cell. See screenshot:

doc-convert-column-to-rows2

Kutools for Excel's Transform Range tool can help you easily transform a single column to a range, transform a single row to a range, transform a range to a single row and transform a range to a single column. Click to know more…


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.
screen shot

btn read more btn download btn purchase

De en het

Posted: 29 Nov 2011 05:27 AM PST

Lane <com> wrote in news:2011112914274122310-lp@gmailcom:
 

Berichten over dit onderwerp plaatsen in nieuwsgroepen anders dan nl.taal
is pas verloedering en zeker niet vernieuwend ...

Any way to restore the 35-color color picker?

Posted: 31 Aug 2011 02:36 PM PDT


In article <individual.net>,
Michael Vilain <net> wrote: 

Well, I don't *need* it; it's just easier to find the colors
I want when they're all on a simple chart. And as I said, there
may be a way to replicate that chart with the Theme mechanism;
I just haven't found a way to do it yet.


Patty

Microsoft Word 2011 has a serious PDF export bug

Posted: 10 Feb 2011 11:07 AM PST

On 2011-02-10 19:07:42 +0000, Geico Caveman said:
 

It's a known issue. I have the same problem with PDF images inside text boxes.
When you generate a PDF, the resulting file shows them as blank.

A critical problem for us here!!
I would *strongly* encourage you to use Help > Send Feedback in Word to
let MS know how significant you consider the issue to be.

My only workaround is to generate the PDF from Word 2008 (or Word 2010
under Windows).

Corentin


--
--- Office:Mac MVP http://www.cortig.net/wordpress/ ---
http://www.mvps.org - http://mvp.support.microsoft.com
MVPs do not work for MS - Les MVP ne travail lent pas pour MS

How to control your Office 2011 update installation.

Posted: 02 Nov 2010 05:40 PM PDT

Dear Corentin & friends:

Corentin Cras-Méneur <mvps.org> wrote: 

Thanks a lot!!

--
Enviado desde mi iPad, Juan I. Cahis, Santiago de Chile.

Office 2011

Posted: 10 Aug 2010 04:21 PM PDT


Want to say that I'm impressed with 2011. Many things on my wish list
were done to improve older versions*the tiny Style window in Word is
better than the Windows version, Outlook doesn't make you scroll though
a long list of fonts to get to what you want, and the software plays
better with the Mac OS.

I use Office for Windows 2003, 2007, and 2010 and Office for Mac 2004
and 2011. My preference is on the Mac side but I get my work done with
all versions.

Thank you MS.