The All Encompassing Excel Help Thread

[Suburban Rhythm]

I had brought this up awhile ago, as I've been looking for Excel help in the past, and know that I've been able to help (I hope) a few people in the past. Figured it would be nice to have everything in one spot.

As time permits, I'll go through and try and add descriptions to each thread so they are easy to find a solution.

Formatting
Ping: Excel gurus - changing decimal separator - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=82858)

Conditional Formatting-Excel - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=82569)

Another Excel help thread - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=77085)

Excel: Or How I learned to Start Worrying and Want to Bomb Microsoft - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=65203)

Is excel smart enough... - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=65042)

Yet Another Excel Help Thread - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=61224)

Excel Question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=58406)

More Excel stuff - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=56792)


Duplicates
PING Excel gurus - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=82601)


Formulae
Excel Questions Thread - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=82271)

Excel budget question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=81058)

PING: Excel People - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=79607)

Another Excel help thread - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=77085)

PING: Excel users ... using functions - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=67841)

PING: Anyone who knows math/excel - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=67735)

Excel Help - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=67467)

Emergency Ping: Excel Gurus - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=67326)

PING - Excel gurus - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=64341)

Friday Fun- Looking for some excel help - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=66483)

Excel Question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=64061)

Ping: Excel People - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=63219)

My first Excel Guru Thread - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=61588)

Excel Formula Help Part III - Final Question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=61514)

Excel Help - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=60056)

Question for the excel guru's - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=59938)

Need help with an excel formula... - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=59615)

quick excel formula/question - semi urgent - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=59549)

Excel if/than formula help - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=59328)

Some Excel help please - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=57358)

excel question about finding a number in a series - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=58732)

excel & dates (aka ping: frogman) :) - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=57523)

Graphs/Charts
Graph Drawing Software Suggestions - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=81416)

Need quick Excel help if possible - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=77411)

Sorting/Filtering
Excel question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=81297)

Protecting Worksheets
Excel Help - Hiding/locking/protecting sheets - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=79344)

Copy/Paste
Excel Help - Copying paragraphs from Word - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=79126)

Images
Microsoft Excel question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=77363)

VBA/Macros
Excel Help - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=81466)

Excel Formula Help Part III - Final Question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=61514)

PING: Visual Basic question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=59689)

Searching Data
ping MS Excel gurus: quick question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=60930)


Unexplainable Phenomena
Curious Excel question - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=82620)

Weird Excel Issue... - Front Office Football Central (http://www.operationsports.com/fofc/showthread.php?t=79636)

[Vince, Pt. II]

Thought this would be a good place for this question:

I've got a list of un-sorted data. I would like to create a new list with the same data, alphabetized. Solutions online seem exceptionally complicated - is there something I'm missing? This seems like it shouldn't be terribly difficult.

Alternate question: is there a way to lock in formatting so that when I copy and paste data, it leaves the formatting static? I'm using a light gray fill on alternating lines to make my table more readable, but cutting and pasting is bringing the fill along for the ride.