Ctrl + ! Formats as a number in case you ever run into this problem. If anybody wants an Excel training let me know
@I floop the pig, ..................
@I floop the pig, so ctrl shift 1? Because isn’t ! Typically under the 1 key?
@I floop the pig, this actually is really helpful, I’ll have to try it. Took a Microsoft office class in college years ago but have never had to use it before my new job. Use Excel everyday now and feel really dumb.
@I floop the pig, tell me all about macros
@I floop the pig, meeeee
@I floop the pig, I have an excel with many small columns and I want to see what I wrote after I left the box. I know there is a toggle option so that long lines are broken in several lines and the box gets bigger but it doesnt work, if I do a manual break. (Alt + Enter) The second line is then hidden after leaving the box. Is there a setting to change that?
@80think08, so it sounds like the row height needs to be adjusted. You can either click wrap text in the home ribbon. Wich will auto adjust row height based on the amount of lines in a cell. Or you can manually adjust the row height
@Bionicbonk, what do you want to know about them? Writing your own, how they work, sources to learn how to make them?
@unknownhero42, yup you've got it
@I floop the pig, just saved me a mild frustration at work. Thank you for the shortcut. I usually just format the cell, but this saved me some time.
@Cruxio , happy to help! If you work with export data another issue can be numbers formatted as text or dates formatted as text. You can fix those with text to columns in the data ribbon
@I floop the pig, do you have a messaging app that would make contacting you easier? And do you accept unsolicited dick pics as payment for extensive help/multiple questions?
@Drunk Pantless Uncle, I don't offhand but I could make one. Unless you want to use my Reddit account to contact me.
@I floop the pig, writing my own. I’ve wanted to take a class about them to use at a work. I have the idea of what I want to do with them. It’s just executing them. I’ve done many trials with many many errors.
@Bionicbonk, gotcha. There are a bunch of ways to get started. One way is to start by recording a simple macro and trying to read it on your own to understand what the code is doing. Once you get good at that start taking out lines that aren't needed for the code. Then you can start using variables to meet specific goals or to identify specific cell ranges. MrExcel and Stack Overflow are great resources for learning how to program in VBA. The learning curve can be difficult in the beginning, but once you figure it out it comes quickly. If you have a specific code in mind I can leave my Reddit account info and then contact me through there
@I floop the pig, I have a sheet where the dates are vertical in d/m/y format and weekly I have to change the dates one by one because if I grab a sample and pull all it does is change the year. What can I do so that I don't have to do that?
@Sriracha, Dates are still technically a number format, so you can have the first date be changeable then for the rest going across, you would do assuming the first date is A1, =A1 +1 then the next you could fill right and it would be =B1 +1
@Sriracha, you can also use Ctrl + R to copy data to the right, Ctrl+D to copy down a column
@Drunk Pantless Uncle, @Bionicbonk @Sriracha @Cruxio
I set up an email if any of you need any other help at any point, or want me to send you copies of the Excel training I run at work. Feel free to share the email with people as well
@I floop the pig, this will actually help me a whole lot at work. Thank you! Have an awesome "helped a stranger" upvote!
@Stealthnuker, happy to help! If you have any other questions please email me at the email I posted in here somewhere haha
I don't use Excel, what the fvck
@MrWonka, Excel like Google tends to "jump the gun" and auto fill what it thinks you want. Then proceeds to make you search up 12.5GB of Hent@i, and immediately download it to a folder named "Office Paperwork" which you forget is on your Google shared drive with you're entire department. To which you have to complete 12.5 hours of HR training because Susan from accounting got wind of it and wrote a 12.5 page long letter to every supervisor in the company stating how the workplace is full of toxic masculinity...
If you don’t know how to use excel by now your moms a hoe
@ImNotRacistBut, I upvote you not because i know how to use excel, but because my mom in fact be a hoe.