Get instant live expert help on I need help with group worksheets in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
i need to reference a group of worksheets into one worksheet as a summary, as the other worksheets data changes, I need the summary top change too
Solved by M. H. in 18 mins
Group the Valley through Mills worksheets. Create a formula in cells D5:D15 to calculate the total charges for each instrument. With the worksheets still grouped, format cells C5:D16 with the Accounting Number Format with no decimals.
Solved by S. Q. in 24 mins
I have an excel file with 2 worksheets, I am looking to determine the age group of each row (yellow highlighted area) - using the age group definitions on both sheets. Someone helped me earlier which was GREAT but I was hoping I could get the sheet updated.
Solved by G. J. in 21 mins
Hi, I have a table that shows a list of groups (group a, group b etc) and displays that there are 2 people in group 'a', 5 people in group 'b', 2 people in group 'c', 6 people in group 'd' etc... I would like to format/display the list show so it only shows the groups that have 2 or less people in each group... I am a complete excel novice.... Thanks you!
Solved by T. Q. in 26 mins
Group the two worksheets. Merge and center the title in cell A1 across the range A1:G1 and apply the Title cell style. Merge and center the subtitle in cell A2 across the range A2:G2 and apply the Heading 1 cell style. AutoFit Column A. Center the worksheets Horizontally, change the Orientation to Landscape.
Solved by E. E. in 17 mins