Please help! I will give thumbs up and review!! (Part 4 of 11) ...
90.2K
Verified Solution
Link Copied!
Question
Finance
Please help! I will give thumbs up and review!! (Part 4 of 11)
10 Freeze Rows and or Columns at the Top or Left of Your Workbook so That Headings Stay in Place While You Scroll Down the Worksheet. How To: Place your cursor at the intersection of the rowscolumns you want fixed in place, i.e. Frozen then > View tab of the ribbon > Freeze Panes. Task Instructions: Freeze the first column so that it keeps the first column visible while scrolling through the rest of the worksheet. Do not freeze any rows. 11 Hide Worksheet Tabs How To: Pight click on the tab name > Select Hide Task Instructions: Hide the tab within this workbook that is called Sec 1-Hide Me. 12 Use Text to Columns to Separate a Column of Data Containing First Names and Last Names How To: Let's say you have First Names and Last Names separated by a space in a column. Select the cells > Data > Text to Columns > Delimited > Next > Choose Delimiter (space in this example) > Next > Select column data format and Destination > Finish. The warning will tell you there is already data here if the destination includes the cells that include the text. You can click Dk. Task Instructions: Use Text to Columns to separate the names listed below into the First Name and Last Name columins
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!