geekhack

geekhack Community => Off Topic => Topic started by: Michael on Thu, 14 January 2016, 13:07:04

Title: MS Office Excel wizard?
Post by: Michael on Thu, 14 January 2016, 13:07:04: Anyone know how to insert multiple rows into a single cell? I swear to Jeebus I know this has been done before, but I can't figure it out -_-

halp
Title: Re: MS Office Excel wizard?
Post by: FLFisherman on Thu, 14 January 2016, 13:08:33: Alt + enter? Multiple lines in same cell.
Title: Re: MS Office Excel wizard?
Post by: SpAmRaY on Thu, 14 January 2016, 13:16:46: nevermind derp
Title: Re: MS Office Excel wizard?
Post by: romevi on Thu, 14 January 2016, 13:18:07: Quote from: FLFisherman on Thu, 14 January 2016, 13:08:33
Alt + enter? Multiple lines in same cell.

Yeah, this. Are you talking about inserting another line of text in a single cell? 'Cause a row is...well, a row.
Title: Re: MS Office Excel wizard?
Post by: Michael on Thu, 14 January 2016, 13:59:53: Quote from: FLFisherman on Thu, 14 January 2016, 13:08:33
Alt + enter? Multiple lines in same cell.

No. Not multiple lines. Multiple rows, like individual cells within a cell, like html tables, essentially.

Like this:

(https://i.imgur.com/pDgAxqC.jpg)
Title: Re: MS Office Excel wizard?
Post by: intelli78 on Thu, 14 January 2016, 14:01:56: Merge cells.
Title: Re: MS Office Excel wizard?
Post by: HoffmanMyster on Thu, 14 January 2016, 14:02:28: To do like in your picture you need to merge the cells that you don't want to be separate rows. But be warned that merging a ton of cells creates a headache for anyone downstream that needs to heavily modify the spreadsheet. :P
Title: Re: MS Office Excel wizard?
Post by: baldgye on Thu, 14 January 2016, 14:05:03: Quote from: intelli78 on Thu, 14 January 2016, 14:01:56
Merge cells.

+1

that screenshot just looks like they have merged the cells at the top and bottom...
Title: Re: MS Office Excel wizard?
Post by: Zorberema on Thu, 14 January 2016, 14:05:46: As both hoffman and intelli said; you need to merge cells to make the first big ones. The ones that are multiple rows in one cell is just many cells! :P The first "big cell" (1. in the picture) is just many cells merged together.
Title: Re: MS Office Excel wizard?
Post by: bcredbottle on Thu, 14 January 2016, 14:07:41: Quote from: Bro Caps on Thu, 14 January 2016, 13:59:53
Quote from: FLFisherman on Thu, 14 January 2016, 13:08:33
Alt + enter? Multiple lines in same cell.

No. Not multiple lines. Multiple rows, like individual cells within a cell, like html tables, essentially.

Like this:

Show Image
(https://i.imgur.com/pDgAxqC.jpg)

I think in that pic, it looks like the larger cells are merged while the cells with multiple rows are just regular cells that look split or fractured because of all the merged cells nearby. F15-F22, for example, all have their own row numbers but C15-C22 don't because they're merged.
Title: Re: MS Office Excel wizard?
Post by: dgneo on Thu, 14 January 2016, 14:08:52: I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
(https://i.imgur.com/2kabiSI.jpg)
Title: Re: MS Office Excel wizard?
Post by: Michael on Thu, 14 January 2016, 14:09:02: Awesome, appreciate the help guys! Let me try this

(http://i.imgur.com/0L3pV.gif)
Title: Re: MS Office Excel wizard?
Post by: baldgye on Thu, 14 January 2016, 14:24:51: Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

(http://i.imgur.com/GaC9XP3.png)
Title: Re: MS Office Excel wizard?
Post by: dgneo on Thu, 14 January 2016, 14:26:46: Quote from: baldgye on Thu, 14 January 2016, 14:24:51
Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

Show Image
(http://i.imgur.com/GaC9XP3.png)

Sure you can add it after the fact, but it looks like **** :thumb:
Title: Re: MS Office Excel wizard?
Post by: baldgye on Thu, 14 January 2016, 14:28:33: Quote from: dgneo on Thu, 14 January 2016, 14:26:46
Quote from: baldgye on Thu, 14 January 2016, 14:24:51
Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

Show Image
(http://i.imgur.com/GaC9XP3.png)

Sure you can add it after the fact, but it looks like **** :thumb:

its an excell spread sheet what the **** do you want it to look like?
Title: Re: MS Office Excel wizard?
Post by: dgneo on Thu, 14 January 2016, 14:29:33: Quote from: baldgye on Thu, 14 January 2016, 14:28:33
Quote from: dgneo on Thu, 14 January 2016, 14:26:46
Quote from: baldgye on Thu, 14 January 2016, 14:24:51
Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

Show Image
(http://i.imgur.com/GaC9XP3.png)

Sure you can add it after the fact, but it looks like **** :thumb:

its an excell spread sheet what the **** do you want it to look like?

(http://rack.0.mshcdn.com/media/ZgkyMDE0LzEwLzIwLzFiL21vbmFfbGlzYS4zMDNiZi5wbmcKcAl0aHVtYgkxMjAweDk2MDA-/56b80b42/3e5/mona_lisa.png)

STEP YA EXCEL GAME UP BRUH
Title: Re: MS Office Excel wizard?
Post by: Zorberema on Thu, 14 January 2016, 14:33:18: Quote from: dgneo on Thu, 14 January 2016, 14:29:33
Quote from: baldgye on Thu, 14 January 2016, 14:28:33
Quote from: dgneo on Thu, 14 January 2016, 14:26:46
Quote from: baldgye on Thu, 14 January 2016, 14:24:51
Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

Show Image
(http://i.imgur.com/GaC9XP3.png)

Sure you can add it after the fact, but it looks like **** :thumb:

its an excell spread sheet what the **** do you want it to look like?

Show Image
(http://rack.0.mshcdn.com/media/ZgkyMDE0LzEwLzIwLzFiL21vbmFfbGlzYS4zMDNiZi5wbmcKcAl0aHVtYgkxMjAweDk2MDA-/56b80b42/3e5/mona_lisa.png)

STEP YA EXCEL GAME UP BRUH

What is that ****, she doesn't even have eyebrows
Title: Re: MS Office Excel wizard?
Post by: baldgye on Thu, 14 January 2016, 14:34:14: Quote from: dgneo on Thu, 14 January 2016, 14:29:33
Quote from: baldgye on Thu, 14 January 2016, 14:28:33
Quote from: dgneo on Thu, 14 January 2016, 14:26:46
Quote from: baldgye on Thu, 14 January 2016, 14:24:51
Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

Show Image
(http://i.imgur.com/GaC9XP3.png)

Sure you can add it after the fact, but it looks like **** :thumb:

its an excell spread sheet what the **** do you want it to look like?

Show Image
(http://rack.0.mshcdn.com/media/ZgkyMDE0LzEwLzIwLzFiL21vbmFfbGlzYS4zMDNiZi5wbmcKcAl0aHVtYgkxMjAweDk2MDA-/56b80b42/3e5/mona_lisa.png)

STEP YA EXCEL GAME UP BRUH

(http://i.imgur.com/NPjMYkz.png)

merged cells
Title: Re: MS Office Excel wizard?
Post by: romevi on Thu, 14 January 2016, 14:35:56: Quote from: Zorberema on Thu, 14 January 2016, 14:33:18
Quote from: dgneo on Thu, 14 January 2016, 14:29:33
Quote from: baldgye on Thu, 14 January 2016, 14:28:33
Quote from: dgneo on Thu, 14 January 2016, 14:26:46
Quote from: baldgye on Thu, 14 January 2016, 14:24:51
Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

Show Image
(http://i.imgur.com/GaC9XP3.png)

Sure you can add it after the fact, but it looks like **** :thumb:

its an excell spread sheet what the **** do you want it to look like?

Show Image
(http://rack.0.mshcdn.com/media/ZgkyMDE0LzEwLzIwLzFiL21vbmFfbGlzYS4zMDNiZi5wbmcKcAl0aHVtYgkxMjAweDk2MDA-/56b80b42/3e5/mona_lisa.png)

STEP YA EXCEL GAME UP BRUH

What is that ****, she doesn't even have eyebrows

Can't tell if Joshing or cereal.
Title: Re: MS Office Excel wizard?
Post by: dgneo on Thu, 14 January 2016, 14:36:41: Quote from: baldgye on Thu, 14 January 2016, 14:34:14
Quote from: dgneo on Thu, 14 January 2016, 14:29:33
Quote from: baldgye on Thu, 14 January 2016, 14:28:33
Quote from: dgneo on Thu, 14 January 2016, 14:26:46
Quote from: baldgye on Thu, 14 January 2016, 14:24:51
Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

Show Image
(http://i.imgur.com/GaC9XP3.png)

Sure you can add it after the fact, but it looks like **** :thumb:

its an excell spread sheet what the **** do you want it to look like?

Show Image
(http://rack.0.mshcdn.com/media/ZgkyMDE0LzEwLzIwLzFiL21vbmFfbGlzYS4zMDNiZi5wbmcKcAl0aHVtYgkxMjAweDk2MDA-/56b80b42/3e5/mona_lisa.png)

STEP YA EXCEL GAME UP BRUH

Show Image
(http://i.imgur.com/NPjMYkz.png)

merged cells

Thank god I've got my good buddy Clippy here.

(http://vignette4.wikia.nocookie.net/annoyingorange/images/b/bc/Clippy-suicide.jpg)
Title: Re: MS Office Excel wizard?
Post by: digi on Thu, 14 January 2016, 14:37:23: Quote from: dgneo on Thu, 14 January 2016, 14:36:41
Thank god I've got my good buddy Clippy here.

Show Image
(http://vignette4.wikia.nocookie.net/annoyingorange/images/b/bc/Clippy-suicide.jpg)

I almost forgot about Mr. Clippy!!! Thanks Clippy!!
Title: Re: MS Office Excel wizard?
Post by: Zorberema on Thu, 14 January 2016, 14:49:15: Quote from: romevi on Thu, 14 January 2016, 14:35:56
Quote from: Zorberema on Thu, 14 January 2016, 14:33:18
Quote from: dgneo on Thu, 14 January 2016, 14:29:33
Quote from: baldgye on Thu, 14 January 2016, 14:28:33
Quote from: dgneo on Thu, 14 January 2016, 14:26:46
Quote from: baldgye on Thu, 14 January 2016, 14:24:51
Quote from: dgneo on Thu, 14 January 2016, 14:08:52
I think you're making it more complicated than it needs to be.

1. Select all the cells you want, Right Click > Format Cells
2. Go to the Fill tab, select the color. You'll see all your cells look like one block now.
3. Select smaller selection of cells inside. Right Click > Format Cells
4. Go to the Border tab, select the 'Outline' Preset.

That should do it for you. It'll look like so:
Show Image
(https://i.imgur.com/2kabiSI.jpg)

Show Image
(http://i.imgur.com/GaC9XP3.png)

Sure you can add it after the fact, but it looks like **** :thumb:

its an excell spread sheet what the **** do you want it to look like?

Show Image
(http://rack.0.mshcdn.com/media/ZgkyMDE0LzEwLzIwLzFiL21vbmFfbGlzYS4zMDNiZi5wbmcKcAl0aHVtYgkxMjAweDk2MDA-/56b80b42/3e5/mona_lisa.png)

STEP YA EXCEL GAME UP BRUH

What is that ****, she doesn't even have eyebrows

Can't tell if Joshing or cereal.

(http://www.zerowasteweek.co.uk/wp-content/uploads/formidable/cereal-leftovers-recipe-zero-waste-week.jpg)